Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Jobs will not run
I have seen cases where once in a while you need to 'kick' start it by
manaually running it once.
exec dbms_job.run(job_no)
Also make sure the init.ora parameter job_queue_processes is > 0
and verify the value of parameter
job_queue_interval
Stephen C. Ashmore
Brainbench MVP for Oracle Administration
http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'
"Ronald" <ronald_at_nowhere.com> wrote in message
news:ada77g$v42tj$1_at_ID-87429.news.dfncis.de...
>
> What could be the possible cause of DBMS_JOB
> job not being run?
>
> My job will not run, although it's submitted OK.
> I can see it in USER_JOBS, but it's simply
> not being triggered.
>
> (Now it's 28 hours since NEXT_DATE
> in USER_JOBS for this job. Of course, LAST_DATE is
> still NULL.)
>
> Command, as entered in SQL*Plus:
>
> VARIABLE jobno NUMBER;
> BEGIN
> DBMS_JOB.SUBMIT(:jobno, 'my_proc(sysdate);', SYSDATE+3/1440,
> 'SYSDATE+12/1440');
> COMMIT;
> END;
>
>
>
> Is there some gotcha?
>
> Platform is 8.1.6 on Windows.
>
>
Received on Sat Jun 01 2002 - 05:30:16 CDT