SQL: Disable DBA_JOBS (Older style) jobs

 Requirement

To disable a database job.

Note this is the old style job, since replaced with scheduler APIs.

Solution

select *
from dba_jobs;

Find the ID of the job that you want. Example 23.

begin
  dbms_job.broken(23, true);
  commit;
end;

Select again, you'll see the broken flag set.

select *
from dba_jobs;

 

Acknowledgement

https://stackoverflow.com/questions/14148375/how-to-enable-disable-oracle-job-using-job-id