Re: DBMS_JOB

Josef Lang <100074.1414_at_CompuServe.COM> wrote:

>Hi out there.
>I have a problem with DBMS_JOB. I have submitted a job with
>DBMS_JOB.SUBMIT from within SQLPlus. When i select
>information from 'all_jobs' everything lookes just fine. When I
>force the job to execute with DBMS_JOB.RUN, the job executes and
>'Next_date', 'Next_time' in 'all_jobs' are set to the next time i
>wanted it to execute automatically. But at this time nothing
>happens.

Check your INIT.ORA file for the following parameters:

job_queue_processes
job_queue_interval
job_queue_keep_connections

Luc Pirson, Database System Support
Belgacom sa, Belgium
luc.pirson_at_is.belgacom.be Received on Thu May 02 1996 - 00:00:00 CEST