Monday, January 23, 2012

Check Statistics Advisor Jobs Status


col owner format a20
col job_name format a30
col start_date format a30
select owner,JOB_NAME,START_DATE ,ENABLED,RUN_COUNT,STOP_ON_WINDOW_CLOSE FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME ='AUTO_SPACE_ADVISOR_JOB';

select owner,JOB_NAME,START_DATE ,ENABLED,RUN_COUNT,STOP_ON_WINDOW_CLOSE FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME ='GATHER_STATS_JOB';

No comments:

Post a Comment