DBA Hub

📋Steps in this guide1/1

Enable/disable/drop a dbms_job

-- Get the job number from dba_jobs.

oracle configurationintermediate
by OracleDba
13 views
1

Enable/disable/drop a dbms_job

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
-- 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) ;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!