Wednesday, April 28, 2010

How to enable/disable a scheduled job?

How  to check  the status  of the scheduled  jobs

SQL>select job_name,state from DBA_SCHEDULER_JOBS;
JOB_NAME STATE

------------------------------ ---------------
PURGE_LOG                                  SCHEDULED
FGR$AUTOPURGE_JOB             DISABLED
GATHER_STATS_JOB                 SCHEDULED
AUTO_SPACE_ADVISOR_JOB SCHEDULED
MGMT_CONFIG_JOB                   SCHEDULED
MGMT_STATS_CONFIG_JOB    SCHEDULED

How to disable  a scheduled  job  e.x   AUTO_SPACE_ADVISOR_JOB

SQL>Exec DBMS_SCHEDULER.DISABLE('AUTO_SPACE_ADVISOR_JOB');

How  to enable  a scheduled  job  e.x   AUTO_SPACE_ADVISOR_JOB

SQL>Exec DBMS_SCHEDULER.enable('AUTO_SPACE_ADVISOR_JOB');

No comments: