How to stop automatically the job of the chain where steps are finished.
787058Aug 25 2010 — edited Aug 30 2010Good Morning,
I'm new on oracle scheduler, i'm doing a sched. chains that runs sched. programs (that runs stored procedures..) on Oracle 11R2.
To run the chain i start the job (created by me or automatically by the DBMS_SCHEDULER.RUN_CHAIN), and once the chain is running and the sched. programs are finished the chain become "Stalled" as written on here:
http://download.oracle.com/docs/cd/E11882_01/server.112/e10595/scheduse006.htm
so when I select from the ALL_SCHEDULER_RUNNING_CHAINS I find, for example 2 steps "SUCCEDED" and when i select from ALL_SCHEDULER_RUNNING_JOBS
I still find the job of the chain running and waiting (ELAPSED_TIME goes by...)
Now, to stop the chain I have to "stop" manually the JOB (then chain will not be in "running" mode anymore), is there any way to a stop the JOB automacally when alls steps of the chain are "SUCCEDED"?
Thanks in advance Marco.