oracle System Schedule（系统任务）

Oracle数据库提供了类似System Schedule（系统任务）的功能，叫做Job。
创建新Job的Procedure脚本如下：
create or replace PROCEDURE  NEW_JOB
(runtime in varchar2,department_name in varchar2,mail_subject in varchar2) AS
n number;
BEGIN
  DBMS_JOB.SUBMIT(n,'STATIONARY_LIST(''' || department_name || ''',''' ||mail_subject ||''');',to_date(runtime,'yyyy-mm-dd hh24:mi:ss'));
  COMMIT;
END;


修改JOB的Procedure脚本如下：


create or replace PROCEDURE  EDIT_JOB
(job_id in number,runtime in varchar2,department_name in varchar2,mail_subject in varchar2) AS
BEGIN


  DBMS_JOB.CHANGE(job_id,'STATIONARY_LIST(''' || department_name || ''',''' ||mail_subject ||''');',to_date(runtime,'yyyy-mm-dd hh24:mi:ss'),null);
  COMMIT;
END;