Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Schedule to run twice a day at different times.

528564Mar 21 2007 — edited Mar 22 2007
Hi
I am trying to write a schedule to run twice a day, 7 days a week at 11.30am and 0.01am (i.e one minute after midnight).

I have tried setting the repeat_interval = 'FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN;BYHOUR = 11,0;BYMINUTE=30,1';

However, this causes the job to run at 11:01; 11:30, 00:01 and 00:30. Can some please show me how to get it to run only at 11:30 and 00:01?

Thanks.
jov
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2007
Added on Mar 21 2007
5 comments
1,618 views