This content has been marked as final. Show 4 replies
- to stop a running chain job step you can use dbms_scheduler.stop_job('owner.jobname.stepname')
- to alter the state of a running job chain step you can use the dbms_scheduler.alter_running_chain procedure. So for example you can use this to change the step state to NOT_STARTED so the step will be run again.
Thanks. I thought dbms_scheduler.stop_job is meant for job_name alone. I tried to change the state of a running chain step to 'SUCCEEDED' using dbms_scheduler.alter_running_chain, however it indicated that the job is not running. I will try changing the state to 'NOT STARTED' and see what happens.
Changing the state of a running chain step to SUCCEEDED is intended to skip a step or a running chain job that has not started yet. Stopping a job step is intended to stop a step that is running, so they do very different things.
Note that you need to pass the chain job name into alter_running_chain .
Thanks. Both the procedures stop_job and alter_running_chain worked as you indicated.