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!

Determining number of times a step runs with chain rules

955874Oct 25 2012 — edited Oct 26 2012
Hi,

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
This post has been answered by spajdy on Oct 26 2012
Jump to Answer

Comments

thatJeffSmith-Oracle
Answer

make sure your data dictionary stats are up to date

Marked as Answer by LPNO · Sep 27 2020
LPNO

Thanks, this was the issue.

begin

    dbms_stats.gather_fixed_objects_stats;

    dbms_stats.gather_dictionary_stats;

end;

It helped, I'm going the schedule this.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 23 2012
Added on Oct 25 2012
1 comment
247 views