my jobs from dbms_job don't run 
Author Message
 my jobs from dbms_job don't run

I've submitted job, but it was never executed by database 8i EE on Tru64.
Does anybody know why? What do I do wrong?
Slawek

JOB
----------
1

LOG_USER
------------------------------
ARTICLES

PRIV_USER
------------------------------
ARTICLES

SCHEMA_USER
------------------------------
ARTICLES

LAST_DATE
--------
01/12/05

LAST_SEC
--------
09:35:48

THIS_DATE
--------

THIS_SEC
--------

NEXT_DATE
--------
01/12/05

NEXT_SEC
--------
09:36:48

TOTAL_TIME
----------
23

BROKEN
------
N

FAILURES
----------------------------------------------------------------------------
------------------ ----------
sysdate + 1/24/60

INTERVAL
---------
0

WHAT
-----------------------------------------------------
DBMS_MVIEW.REFRESH('articles.art_by_time_desc','cf');

NLS_ENV
----------------------------------------------------------------------------
------------------
NLS_LANGUAGE='POLISH' NLS_TERRITORY='POLAND' NLS_CURRENCY='z3'
NLS_ISO_CURRENCY='POLAND'
NLS_NUMERIC_CHARACTERS=', ' NLS_DATE_FORMAT='RR/MM/DD'
NLS_DATE_LANGUAGE='POLISH'
NLS_SORT='POLISH'

MISC_ENV
----------
0102000200000000

INSTANCE
----------------------------------------------------------------
0



Sun, 23 May 2004 18:07:56 GMT
 my jobs from dbms_job don't run

Quote:

> I've submitted job, but it was never executed by database 8i EE on Tru64.
> Does anybody know why? What do I do wrong?
> Slawek

> JOB
> ----------
> 1

> LOG_USER
> ------------------------------
> ARTICLES

> PRIV_USER
> ------------------------------
> ARTICLES

> SCHEMA_USER
> ------------------------------
> ARTICLES

> LAST_DATE
> --------
> 01/12/05

> LAST_SEC
> --------
> 09:35:48

> THIS_DATE
> --------

> THIS_SEC
> --------

> NEXT_DATE
> --------
> 01/12/05

> NEXT_SEC
> --------
> 09:36:48

> TOTAL_TIME
> ----------
> 23

> BROKEN
> ------
> N

> FAILURES
> ----------------------------------------------------------------------------
> ------------------ ----------
> sysdate + 1/24/60

> INTERVAL
> ---------
> 0

> WHAT
> -----------------------------------------------------
> DBMS_MVIEW.REFRESH('articles.art_by_time_desc','cf');

> NLS_ENV
> ----------------------------------------------------------------------------
> ------------------
> NLS_LANGUAGE='POLISH' NLS_TERRITORY='POLAND' NLS_CURRENCY='z3'
> NLS_ISO_CURRENCY='POLAND'
> NLS_NUMERIC_CHARACTERS=', ' NLS_DATE_FORMAT='RR/MM/DD'
> NLS_DATE_LANGUAGE='POLISH'
> NLS_SORT='POLISH'

> MISC_ENV
> ----------
> 0102000200000000

> INSTANCE
> ----------------------------------------------------------------
> 0

Did you set the job_* parameters in your init.ora?
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.


Sun, 23 May 2004 20:46:20 GMT
 my jobs from dbms_job don't run

Quote:

> I've submitted job, but it was never executed by database 8i EE on Tru64.
> Does anybody know why? What do I do wrong?
> Slawek

I guess what you posted is a query against the table user_jobs
(or is it dba_jobs?)

The Total_time field has a value so your job has run already once.
You may repeat the query against the user_jobs table, as you have
an intervall of 1 minute, the field LAST_SEC should change every
minute.
In my opinion the job was executed and the BROKEN flag is not set
so it does not seem to be corrupt.

Open questions:
==============
* How did you install the job? Did you use the package DBMS_JOB?

As I rather assume the problem is in the procedure/package that you
use during execution, there are some more questions:

* Do you use database links in your package? I had some problems
  with database links inside jobs -> My solution was to swap to
  the OS scheduler and execute a SQL*Plus Script.
* What about package variables in the package? The job queue opens
  a new session to execute the job.

Finally, have you looked in the alert logs of the database instance?
Should be called something like <SID>ALRT.log.
Sorry, can't help you with the exact location of this file, as my
knowledge ends with Oracle 8.05 on Windows NT.

Not sure if this helps you, but it may give you some hints on where
to start..
Of course you can always tried it with a second post with more detailed
information.

Cheers, Rolf.

Quote:
> LAST_DATE
> --------
> 01/12/05

> LAST_SEC
> --------
> 09:35:48

> NEXT_DATE
> --------
> 01/12/05

> NEXT_SEC
> --------
> 09:36:48

> TOTAL_TIME
> ----------
> 23

> BROKEN
> ------
> N

!? Next two fields seems to be exchanged ?!

- Show quoted text -

Quote:
> FAILURES
> ----------------------------------------------------------------------------
> ------------------ ----------
> sysdate + 1/24/60

> INTERVAL
> ---------
> 0

> WHAT
> -----------------------------------------------------
> DBMS_MVIEW.REFRESH('articles.art_by_time_desc','cf');



Sun, 23 May 2004 23:31:10 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. triggers don't get exported, dba jobs don't run

2. Stored Procedures don't run in a Job

3. some scheduled jobs don't run in sql 7

4. jobs don't run anymore

5. Jobs don't work via SQL Agent but work when run ad hoc

6. Jobs don't run

7. sql agent jobs don't run

8. Auto-Schedule Jobs Don't Run

9. Job submitted with DBMS_JOB wont run

10. Replication Job ID's don't match

11. Don't duplicate v Don't resend trade-off theory

12. Jobs don't execute as scheduled.


 
Powered by phpBB® Forum Software