Re: DBMS_JOBs not running once submitted

From: James Petts <jpetts_at_celltech.co.uk>
Date: Fri, 23 Apr 1999 07:43:10 GMT
Message-ID: <3720236b.168310447@right.celltech>

On Thu, 22 Apr 1999 16:03:44 GMT, awtracy_at_my-dejanews.com wrote:

>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.

Have you started the server processes which handle the jobs? You do this by setting the variables job_queue_interval and job_queue_processes in your init.ora file. The first specifies in seconds how often the process(es) will wake up to service DBMS_JOB requests, while the second specifies how many processes will be created.

One of our databases has:

job_queue_interval = 10
job_queue_processes = 1 Received on Fri Apr 23 1999 - 02:43:10 CDT