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');
Wednesday, April 28, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment