How do I prevent dbms_job from being re-executed.
Posted on 2006-11-09
I have submitted a job through dbms_job.submit package. Suppose, if anything goes wrong , I want the job to be broken and stop from being re-executed.
How do I achieve this?
One way of doing this is , if I see any error, I can use the dbms_job.broken package manually and remove the job from job queue.
But this is not what I am looking for.
Is there any way that I can achieve this at the same time I submit the job and dont have to do it manually.