Re: DBMS_JOBs not running once submitted

We had a very similar problem - so you could be suffering the same thing.

The concept is, you are not launching a job, you are writing data about a potential job. And in Oracle database terms all data is not available to other processes - even Oracle's own processes for Job Execution until the data has been committed. Try the DBMS_JOB line and then COMMIT.

Seems obvious to us now but it took some time to track down.

Regards

Kevin

--
The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. <awtracy_at_my-dejanews.com> wrote in message news:7fnh8t$lkn$1_at_nnrp1.dejanews.com...
> Hello !
>
> This one has bugged me for a while. We are running a procedure which
contains
> a handful of calls to dbms_job.submit to set up some repetitive jobs
varying
> from 5 seconds to 24 hours in interval. However, occasionally the jobs
will
> not run once they have been submitted and need to be nudged into working
by
> issuing a dbms_job.run command directly from SQL*Plus.
>
> I can't work out under what circumstances the jobs don't run immediately.
> Can anyone help me out here ?
>
> PS. Seems to happen under 7.3.4 and 8.0.5, and it's an AIX platform
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Apr 22 1999 - 11:23:40 CDT