Skip to Main Content
Forums

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!

Reg: Enable/disable jobs automatically -

915396May 28 2016 — edited Jun 3 2016

Hi Experts,

I have three scheduler jobs, say - JOB_INFLOW (runs every 1 min), JOB_OUTFLOW_1 & JOB_OUTFLOW_2 (both runs once a day at 22:00 hrs).

My requirement is - once the JOB_OUTFLOW_1 and _2 starts at 22:00, the JOB_INFLOW should be stopped. Once both OUTFLOW_1 and _2 completes, resume the INFLOW job again.

I tried - disabling INFLOW job while starting OUTFLOW jobs, but if the former is in running state it will throw an exception.

Any suggestions how to achieve this ?

Is chaining the only way using DBMS_SCHEDULER ?

Thanks and Regards,

- Ranit

( on Oracle 11.2.0.4.0 )
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2016
Added on May 28 2016
14 comments
2,491 views