DBA Hub

📋Steps in this guide1/1

Manage dbms_schedulerjobs

Enable a job

oracle configurationintermediate
by OracleDba
14 views
1

Manage dbms_schedulerjobs

Enable a job Disable a job Stop a running job Drop a running job Run a job immediately

Code/Command (click line numbers to comment):

1
2
3
4
5
EXECUTE DBMS_SCHEDULER.ENABLE('SCOTT.MONTHLYBILLING');
EXECUTE DBMS_SCHEDULER.DISABLE('SCOTT.MONTHLYBILLING');
EXECUTE DBMS_SCHEDULER.STOP_JOB('SCOTT.MONTHLYBILLING');
EXECUTE DBMS_SCHEDULER.DROP_JOB('SCOTT.MONTHLYBILLING');
EXECUTE DBMS_SCHEDULER.RUN_JOB('SCOTT.MONTHLYBILLING');

Comments (0)

Please to add comments

No comments yet. Be the first to comment!