oracle定时任务的实现

1.创建存储过程

CREATE OR REPLACE PROCEDURE delete_old_records AS
BEGIN
  DELETE FROM im_method_aop
  WHERE TO_DATE(VISIT_TIME, 'YYYY-MM-DD HH24:MI:SS') <
        TRUNC(SYSDATE - INTERVAL '7' DAY);
  COMMIT;
END delete_old_records;

2.创建定时任务job,这里通过语句来创建定时任务：

declare
  DELETE_IM_METHOD_AOP_JOB number;
begin
  dbms_job.submit(DELETE_IM_METHOD_AOP_JOB, 'delete_old_records;',  sysdate, 'sysdate + 7');
end;

3.创建成功后可以在plsql的DBMS_Jobs里看到相关信息