Defining schedule in a scheduler sets the schedule to be started in next year instead of this year 2
I am trying to create a schedule that will comply to the following requirements.
1. Runs on JAN,MAY,JUL,SEP
2. On the 3rd saturday of the month
3. Runs at 3am
I created a schedule as follows
sys.dbms_scheduler.set_attribute( name => '"OWNER1"."SCHEDULE_JANMAYJULSEP_3RD_SAT"'
, attribute => 'repeat_interval',
value =>'FREQ=YEARLY;BYMONTH=JAN,MAY,JUL,SEP;BYDAY=3SAT; BYHOUR=3');
The problem we notice was this was getting scheduled to start on Jan 19, 2013 as opposed to May 19, 2012.
Any thoughts or comments much appreciated.
Thanx,
Sam
0