This discussion is archived
1 Reply Latest reply: Oct 26, 2012 5:54 AM by spajdy RSS

Determining number of times a step runs with chain rules

955874 Newbie
Currently Being Moderated

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 - 64bit Production
PL/SQL Release - Production
  • 1. Re: Determining number of times a step runs with chain rules
    spajdy Pro
    Currently Being Moderated
    I think that you must analyze dba_scheduler_job_log view. There is logged job/chain start adn then every step run.
    So chain will have step1 and step1check.
    There will be rule that run step1check after step1 complete.
    In step1check you look to dba_scheduler_job_log to find how step1 finished.
    If you found that step1 fails for second time you send an email.
    Error_code of step1check will be used to make decision to run setp1 again or to end chain.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points