Manage dbms scheduler jobs in Oracle

Enable / Disable , Stop / Run , Drop the DBMS Scheduler jobs in Oracle

Enable a dbms scheduler job

EXECUTE DBMS_SCHEDULER.ENABLE('SCHEMANAME.JOBNAME');

Disable a DBMS Scheduler job

EXECUTE DBMS_SCHEDULER.DISABLE('SCHEMANAME.JOBNAME');

Stop a running job

EXECUTE DBMS_SCHEDULER.STOP_JOB('SCHEMANAME.JOBNAME');

Drop a running job

EXECUTE DBMS_SCHEDULER.DROP_JOB('SCHEMANAME.JOBNAME');

Run a job immediately

EXECUTE DBMS_SCHEDULER.RUN_JOB('SCHEMANAME.JOBNAME');

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.