can anyone provide some information on how to disable a dbms job. ??
thanks
Printable View
can anyone provide some information on how to disable a dbms job. ??
thanks
if you want to stop all jobs, you can change init parameter JOB_QUEUE_PROCESSES ... if you set it to 0, no job will run.
else if you just want to work on 1 job, you can either remove it (= delete it), or if you just want to disable it for a time, use dbms_job.broken, so it won't run next time, until you act on it again ;)