Repeat_interval set up in dbms_scheduler.create_job
HerndonMay 22 2012 — edited May 22 2012Gurus,
I need to set up a job to run 4 times in a year(1st on JAN,APR,JUL,OCT at 9 am).
I have tried following code and got invalid values error for repeat_interval .Please help me to fix this.
dbms_scheduler.create_job (job_name => 'PROCESS_JOB',
job_type => 'stored_procedure',
job_action => 'SNAP_PROC',
start_date => trunc(sysdate)+ 9/24,
repeat_interval => 'FREQ=MONTHLY;BYMONTH=JAN,APR,JUL,OCT;BYDAY=1;BYHOUR=9',
end_date => null,
enabled => false,
auto_drop => false,
comments => 'Snapshot Process);
--
Anan