How to enable/disable scheduled jobs on Oracle Databases using dbms_scheduler procedure

Products

• VMware vCenter Server

Issue/Introduction

In order to enable or disable a job that has been scheduled within Oracle database (via dbms_scheduler), one needs to first need to identify the job_name and then pass this job_name to the dbms_scheduler.enable  or dbms_scheduler.disable command:

To know how to enable or disable a job that has been scheduled within Oracle database using dbms_scheduler procedure.

Environment

VMware vCenter Server 6.0.x
VMware vCenter Server 5.5.x
VMware vCenter Server 6.x
VMware vCenter Server 6.5.x
VMware vCenter Server 6.7.x

Resolution

While logged into the Oracle database as a system userid or schema owner, do the following:

• To check the job status:

SQL> select job_name, owner, enabled from dba_scheduler_jobs;

• To Disable a job:

SQL> execute dbms_scheduler.disable('owner.job');

Example:
dbms_scheduler.disable (job_name => 'xxxx');
end;
/

• To enable a job:

SQL> execute dbms_scheduler.enable('owner.job');

Example:
dbms_scheduler.enable (job_name => 'xxxx');
end;
/

Additional Information

Impact/Risks:
Unable to schedule jobs in Oracle databases.