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) ;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.