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