Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Jobs will not run

Re: Jobs will not run

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Sat, 1 Jun 2002 05:30:16 -0500
Message-ID: <ufh8hpdh47r5f8@corp.supernews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US