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!

First day of the month between 8am and 6:30 pm

greenySep 1 2010 — edited Sep 1 2010

DB Version: 10.2.0.4

Due to the nature of our business the first day of every month(Like today Sep 1st) , the DB will be very busy.
We execute a purging proc scheduled from Windows scheduler every 5 minutes every day.

But on the first day of every month (Like today Sep 1st), if it is a weekday (Mon-Friday) we don't want this proc to be running between 8am and 6:30pm evening.

So, i thought of including the logic within the procedure itself .

How can i implement this?

Edited by: user872043 on Sep 1, 2010 8:48 AM

This post has been answered by Centinul on Sep 1 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2010

Added on Sep 1 2010

6 comments

1,319 views