查看所有job:
SELECT * FROM dba_jobs;
========================================================================
1.创建存储过程
https://www.cnblogs.com/xujingyang/p/6642030.html(plsql语法)
https://blog.csdn.net/u011521890/article/details/52527695(游标)
https://www.cnblogs.com/senyier/p/6611478.html(完整的存储过程)
2.创建Job(使用pl/sql)
https://blog.csdn.net/wyqlxy/article/details/40538633(时间间隔)
DBMS_JOB的 SQL
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => '存储过程名称'
,next_date => to_date('04/07/2017 00:00:00','dd/mm/yyyy hh24:mi:ss') --下次执行时间
,interval => 'TRUNC(LAST_DAY(SYSDATE))+4' --每月4号0点
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;