I know this is very simple,but here it is,
col JOB_NAME for a30
col START_DATE for a30
col LAST_START_DATE for a30
col NEXT_RUN_DATE for a30
select JOB_NAME,START_DATE,LAST_START_DATE,NEXT_RUN_DATE,JOB_ACTION from DBA_SCHEDULER_JOBS where job_name like '%GATHER%'
SELECT owner, job_name, job_class, enabled FROM dba_scheduler_jobs;
exec dbms_scheduler.disable('GATHER_SYS_STATS_JOB');
col JOB_NAME for a30
col START_DATE for a30
col LAST_START_DATE for a30
col NEXT_RUN_DATE for a30
select JOB_NAME,START_DATE,LAST_START_DATE,NEXT_RUN_DATE,JOB_ACTION from DBA_SCHEDULER_JOBS where job_name like '%GATHER%'
SELECT owner, job_name, job_class, enabled FROM dba_scheduler_jobs;
exec dbms_scheduler.disable('GATHER_SYS_STATS_JOB');
No comments:
Post a Comment