Schedule "Nested" Recurring Job
641128May 23 2008 — edited May 23 2008I am trying to schedule a job that will start running every Sunday evening and run every 5 minutes thereafter until early Monday morning. Without hardcoding the start and end dates, I can't get the start, end and repeat interval to work properly. I have also tried using a schedule outside the job.
Any suggestions on how I might get this to work or where I can find a similar example?
Thank you.
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'FILE_WATCH_TEST_JOB'
,job_type => 'STORED_PROCEDURE'
,job_action => 'FILE_WATCH'
,number_of_arguments => 2
,start_date => TO_DATE('2008-05-25 19:55:00','YYYY-MM-DD HH24:MI:SS')
,end_date => TO_DATE('2008-05-26 06:55:00','YYYY-MM-DD HH24:MI:SS')
,repeat_interval => 'FREQ=MINUTELY;INTERVAL=5'
,enabled => FALSE
,comments => 'File Watch Test'
);