Enable or disable the DBMS_JOB

Enable/Disable the dbms_jobs

First get the job number and status of dbms_jobs:
N – Means enable , Y- means disable

     jobno SCHEMA_USE B
---------- ---------- -
WHAT
-------------------------------------------------------------------------------
         1 HR         N
INSERT INTO employees VALUES (7345, 'RAM',
   'SHARMA', 'ram@orcl.com', NULL, SYSDATE, 'AP', NULL,
    NULL, NULL, NULL);

Disable the 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) ;
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply