Re: Job Queues - Question on execution times and sample

>execute dbms_job.submit(:j, 'chk_test;',sysdate,'sysdate+5/24/60');

The next run date will be calculated when the job is actually started (but is actually re-scheduled when the job has finished). So, when the job is started too late, the next jobs start late as well, unless you use some smart calculations.

Sysdate + 1 yields tomorrow, exactly 24 hours after the actual start time. So, sysdate + ( 1 / ( 24 * 60 ) ) is one minute from now; sysdate + 5 * ( 1 / (24 * 60) ) means that the job is rescheduled to run 5 minutes after the actual start date. Note that if your job runs longer than 5 minutes, then you might get into trouble.

Arjan. Received on Wed Sep 16 1998 - 14:04:52 CDT