1、查看有哪些JOB
select * from user_scheduler_jobs
–where upper(job_name)=upper(‘JobTest’)
2、查看正在运行的JOB
SELECT * FROM dba_SCHEDULER_RUNNING_JOBS;
3、创建JOB
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => ‘JOBTEST’,
job_type => ‘STORED_PROCEDURE’,
job_action => ‘PKG_AMS_ZDJM.Proc_Mx_000100_Csjm_START’,
start_date =>sysdate,–to_date(‘20180626200500’,‘yyyymmddhh24miss’),–一次性执行,计算完成后,自动删除job
enabled => true
–repeat_interval => ‘FREQ=MINUTELY;INTERVAL=10’);
);
END;
4、停止JOB
exec dbms_scheduler.stop_job(‘JOBTEST’);
【注意:STOP_JOB 过程不仅仅是更新job 的状态,而是停止当前正在执行的任务,如果你处理的任务当前未在运行的话,那么执行STOP_JOB 过程,会触发ORA-27366 错误】
5、删除JOB
begin
dbms_scheduler.drop_job(‘JOBTEST’);
end;