DBMS_JOBs not running once submitted

From: <awtracy_at_my-dejanews.com>
Date: Thu, 22 Apr 1999 16:03:44 GMT
Message-ID: <7fnh8t$lkn$1@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:03:44 CDT