Re: DBMS_JOB.SUBMIT

Do you mean that the job fails to auto-execute while it runs fine using dbms_job.run()? What errors got recorded in the alert log and/or trace files?

NeedaHoliday wrote:
>
> Has anyone ever had a problem of getting job to execute from the
> queue.
>
> Parameter for JOB_QUEUE_PROCESSES is 3
> JOB_QUEUE_INTERVAL is 60.
>
> If I force the job to run using DBMS_JOB.RUN(), everything works
> great. Is there another parm that needed to be modified to turn the
> reader on.
>
> Oracle 7.3.4
>
> REMOVEjames.stewart_at_pwgsc.gc.ca
>
> Omit REMOVE to email
Received on Thu Apr 06 2000 - 00:00:00 CDT