Using ODI 12c on Windows Server 2008 R2 Standard SP1
I have a scheduled load plan configured to run continuously (Repetition = Many times, Interval between Repetitions = 5 Seconds). I would like to configure this schedule so that, if any of the steps in the load plan raises an exception, the load plan session will automatically be restarted (not start a new execution of the load plan, but restart the error'ed session). But if the load plan fails 5 times consecutively (for any reason), the schedule should become disabled and require manual intervention.
Is this possible?
NOTE: In the schedule, I tried setting Number of Attempts on Failure = 5, but this doesn't work. What is this setting supposed to do?