Oracle JOB

--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;