Skip to Main Content

Database Software

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 can I define jobs so that they can be temporarily removed from schedule

614085Dec 18 2007 — edited Jan 2 2008
I'm fairly new to dbms_scheduler, but I have worked with other job schedulers (CA AutoSys, UC4, etc.) in the past. At prior employers, we always had a need for turning "off" jobs that run on SERVERXYZ (which may or may not be a remote server) when SERVERXYZ had planned downtime. Does anyone have any ideas about how to accomplish this with dbms_scheduler? Ideally, one change (whatever that might be, preferably the manual execution of a "stand by" job) would temporarily disable all jobs related to SERVERXYZ so that they would not attempt to run and subsequently fail during planned downtime.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2008
Added on Dec 18 2007
4 comments
2,561 views