--Job
--禁用和启动作业的方法:
exec dbms_scheduler.disable('GATHER_STATS_JOB');
exec dbms_scheduler.enable('GATHER_STATS_JOB');
--查询job
SELECT * FROM DBA_SCHEDULER_JOB_LOG ORDER BY 2 DESC;
--根据job_name查询JOB的执行情况:
col job_name for a20
col owner for a5
col last_start_date for a36
col last_run_duration for a30
col state for a10
SELECT owner,
job_name,
state,
last_start_date,
last_run_duration,
failure_count
FROM dba_scheduler_jobs
WHERE job_name = 'GATHER_STATS_JOB';
--根据job_name查看GATHER_STATS_JOB运行的具体过程:
select PROGRAM_ACTION from dba_scheduler_programs where PROGRAM_NAME ='GATHER_STATS_PROG';
--根据job_name查看GATHER_STATS_JOB的运行日志:
SELECT log_id, job_name, status,
TO_CHAR (log_date, 'DD-MON-YYYYHH24:MI') log_date
FROM dba_scheduler_job_run_details
WHERE job_name = 'GATHER_STATS_JOB' order by 1 desc;