Re: Execution interval is incorrect while using DBMS_JOB.SUBMIT

Hi,

thank you all for your interest and assistant. My conclusion is that DBMS_JOB does not guarantee an exact start time for the job, it will run "on or about the scheduled time". So critical jobs should be initiated with cronjobs, or other methods more reliable than DBMS_JOB mechanism on this perspective. One way to get better execution time (to decrease the shifting), is to change job_queue_interval parameter value - smaller values will make the engine check for jobs to be executed more frequently (though will decrease the overhead on Oracle).

See further discussion about the issue in http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:13317229864022

Maoz Received on Sun Aug 22 2004 - 04:17:42 CDT