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!

DBMS_SCHEDULER: JOBS failure on database shutdown

VignanDec 11 2013 — edited Dec 12 2013

Hi

I am new to DBMS Scheduler.

We are using dbms scheduler chain and job for executing procedures daily.

But whenever there is database shutdown or crash, job immediately goes into CHAIN_STALLED state.

Is there any way such that after the database restores the chain starts executing from the failed step without manual intervention.

Thanks,

Vignan

This post has been answered by spajdy on Dec 11 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2014
Added on Dec 11 2013
4 comments
5,141 views