Oracle--Job

job的创建

例：

begin
  sys.dbms_scheduler.create_job(job_name            => 'CUST.TEST02',
                                job_type            => 'STORED_PROCEDURE',
                                job_action          => 'del_data',
                                start_date          => to_date('08-04-2019 23:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                                repeat_interval     => 'Freq=Daily;Interval=1',
                                end_date            => to_date(null),
                                job_class           => 'DEFAULT_JOB_CLASS',
                                enabled             => true,
                                auto_drop           => true,--一回実行
                                comments            => '');
end;
/

查询job

１．全部JOB

select * from user_jobs;

２．按照job执行的内容关键字查询

select * from dba_jobs WHERE WHAT LIKE '%cust%'

３．按照job開始执行的時間查询

select t.owner,
       t.job_name,
       t.status,
       to_char(t.actual_start_date, 'yyyy-mm-dd hh24:mi:ss'),
       t.additional_info,
       t.error#
  from dba_scheduler_job_run_details t
 where t.job_name LIKE 'JOB_BY_DD_02%'  --job名字
 and t.actual_start_date < to_date('2018-09-19 12:00:40','yyyy-mm-dd hh24:mi:ss')
 order by log_date desc;

４．按照job運行状態查询

select * from Dba_Scheduler_Running_Jobs

停止JOB

 exec dbms_scheduler.stop_job(‘DEL_POOL’,force => true);