dbms_scheduler chain step failed restart chain to next officially run date
811265Feb 10 2012 — edited Feb 13 2012Hi,
all looking for solution when a step of a job chain run into a error and how I can restart the chain to next run date.
I have dbms_scheduler chain with two steps and it runs every night on a Version 10.2.0.4.
So when the first step runs into a error I want to give time to fix that problem and than restart to next officially run date, also the next night.
I search for second solution in place of drop and create job again.
So I found solutions to start the next step or to restart the failed step directly with alter_running_chain.
But I want that the chain run normally at the next run date.
It is enough to set the failed step to not started with
dbms_scheduler.alter_running_chain('jobname','STEP1','STATE','NOT_STARTED')?
it is necessary to set
dbms_scheduler.set_attribute (NAME => 'jobname', ATTRIBUTE => 'restartable', VALUE => TRUE);
more information needed?
Thanks in advanced
Michael