Skip to Main Content

Oracle Database Discussions

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_CHAINS - Reset chain to auto start next day for its scheduled run

Neel shahFeb 27 2023

Is it possible to restart a chain from the step which failed ?

For example :
I create a chain with 5 steps.

Each step is waiting for the successful completion of the precedent.

step 1 complete succcessfully
step 2 complete succcessfully
step 3 failed
So the chain stop executing.

Imagine I find and correct the problem which made failed the step 3.

I want now to continue the chain with a new execution of step 3 which will completed successful this time,
so the chain will continue with steps 4 and 5.
or

Reset chain to auto start next day for its scheduled run
Is it possible ?

Thanks

Comments
Post Details
Added on Feb 27 2023
0 comments
121 views