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!

dbms_scheduler chain step failed restart chain to next officially run date

811265Feb 10 2012 — edited Feb 13 2012
Hi,
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
This post has been answered by spajdy on Feb 10 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2012
Added on Feb 10 2012
2 comments
1,123 views