Enable/disable/drop a dbms_job - oracle database script

-- Get the job number from dba_jobs.  select job "jobno",schema_user,what from dba_jobs;  -- Disable a job  EXEC DBMS_IJOB.BROKEN(jobno,TRUE);  -- Enable a job  EXEC DBMS_IJOB.BROKEN(jobno,FALSE);  --REMOVE A DBMS_JOBS:  EXEC DBMS_IJOB.remove(jobno) ;