SQL & PL/SQL

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!

How to exculde few hours from Hourly Recurrence pattern in oracle scheduler

Nag AswadhatiMar 10 2014 — edited Mar 17 2014

My Version Details

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

"CORE 11.2.0.3.0 Production"

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

I have schedule a hourly job for 2 days(Startdate: 10-Mar-2014 10:00:00 AM , Enddate: 12-Mar-2014 10:00:00 AM)

But I dont want to run the job on 10-Mar-2014 01:00:00 PM, 10-Mar-2014 02:00:00 PM, 11-Mar-2014 05:00:00 PM and 10-Mar-2014 08:00:00 PM.

Exclude option is not supporing BYHOUR option.

Please suggest me how to achieve this.

Please let me know if you need more information.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2014

Added on Mar 10 2014

6 comments

702 views