Job using Scheduler
792290Apr 18 2011 — edited Apr 18 2011Hello,
I created a Job using dbms_scheduler for weekly report. I am wanted to run this report on every tuesday and if its a holiday on tuesday it should go to the wednesday. I tried to schedule doesn;t work with setpos.
here is my code:
BEGIN
DBMS_SCHEDULER.CREATE_JOB
(JOB_NAME => 'test.WREP',
JOB_TYPE => 'STORED_PROCEDURE',
JOB_ACTION=> 'test.IPREP',
START_DATE => TO_DATE('04/18/2011 14:49:00','MM/DD/YYYY HH24:MI:SS'),
END_DATE => TO_DATE('12/31/2011 23:59:59','MM/DD/YYYY HH24:MI:SS'),
REPEAT_INTERVAL=> 'FREQ=WEEKLY;INTERVAL=1;BYDAY=MON,TUE,WED,THU,FRI;EXCLUDE= FEDERALHOLIDAYS; BYSETPOS=1',
ENABLED=>TRUE,
AUTO_DROP=>FALSE,
COMMENTS=>'EVERY Tuesday SCHEDULE');
END;
can someone please help.