Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Job Queues - Question on execution times and sample
Hello,
I am inseting records into Oracle's Job Queue and the next date and interval of execution in the documentation is not all that clear. Here are some samples. Could someone please clarify when and often these get executed. Most of my Oracle servers check the job queues betweeen 30 seconds and 1 minute.
#1
execute dbms_job.submit(:j, 'chk_test;',sysdate,'sysdate+5/24/60');
#2
execute dbms_job.submit(:j, 'start_test;',sysdate,'sysdate+1');
Thanks,
JasonL Received on Wed Sep 16 1998 - 12:35:36 CDT