Determining number of times a step runs with chain rules
955874Oct 25 2012 — edited Oct 26 2012Hi,
I'm new to developing chains, and want to know how to do the following:
1) I run Step 1
2) If step 1 fails, I want to run Step1 recovery step.
3) When the recovery step completes. I want to re-run Step 1 again.
4) If Step 1 fails for a second time, I want to end the chain, and report/email a failure message.
How do I count the steps, so that I know that Step 1 failed for a second time?
Oracle version:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production