oracle强制停止scheduler,学习笔记:Oracle SCHEDULER 如何创建、修改、关闭、启用计划调度...

天萃荷净

Oracle 计划调度DBMS_SCHEDULER常规操作汇总

1.create job

BEGIN

DBMS_SCHEDULER.CREATE_JOB(

job_name =>'xifenfei_job',

job_type =>'STORED_PROCEDURE',

job_action =>'p_schedule',

repeat_interval =>'FREQ=DAILY; BYHOUR=18,20,22',

enabled => true,

comments => 'XIFENFEI');

END;

--每天18/20/22点执行p_schedule过程

2.disable job

BEGIN

DBMS_SCHEDULER.DISABLE(name => 'xifenfei_job');

END;

3.enable job

BEGIN

DBMS_SCHEDULER.ENABLE(name => 'xifenfei_job');

END;

4.select job

select * from USER_SCHEDULER_JOBS;

5.query logs

SELECT * FROM USER_SCHEDULER_JOB_RUN_DETAILS

WHERE job_name='XIFENFEI_JOB';

6.delete logs

--A