Re: DBMS_JOB fails to schedule job

Richard,

Hope you've set job_queue_processes and job_queue_interval parameters in your init.ora. Set the job_queue_processes to a value depending on the number of jobs you have scheduled. Job_queue_interval defaults to 60 - this is in seconds - this means that the job queue process wakes up every 1 minute to check/run any scheduled jobs. I 've made this parameter to 3600 ( the max value ), 'cos thats just my requirement.

The script looks okay to me. Pls give more details on the two parameters mentioned above.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.

Richard G. Ramirez wrote:


> 

> I am testing DBMS_JOB using Oracle 7.1. I am able to schedule

> the job without errors but the process never executes automatically.When

> I use DBMS_JOB.RUN(2);, it executes without problem and it modifies

> the 'last date' column in DBA_JOBS.

> 

> The two jobs below perform the same thing (insert a row to a table).

> One uses a stored procedure, the other an INSERT as part of

> the DBMS_JOB.SUBMIT.

> 

> My guess is that I don't understand intervals but I can't see

> my mistake.

> 

> Any ideas?

> 

> Thanks.

> 

> Richard

> ------------------------------------------------

> declare

>   job# BINARY_INTEGER;

> begin

>  dbms_job.submit(job#,

>       'insert into rgr.test_job values (sysdate, ''job 2'',33);',

>        sysdate, 'sysdate+1/720');

> end;

> /

> 

> SQL>

> SQL> select job, schema_user,

>   2         to_char(next_date, 'MM/DD/YY HH:MI:SS') next_date,

>   3         to_char(last_date, 'MM/DD/YY HH:MI:SS') last_date,

>   4         interval,

>   5         broken

>   6  --what

>   7  from sys.dba_jobs;

> 

>        JOB SCHEMA_USER  NEXT_DATE            LAST_DATE

> ---------- ------------ -------------------- --------------------

> INTERVAL             B

> -------------------- -

>          3 RGR          11/01/95 03:35:49    11/01/95 03:33:49

> sysdate+1/720        N

> 

>          2 RGR          11/01/95 03:16:30


> sysdate+1/720        N