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