一、创建存储过程
CREATE OR REPLACE PROCEDURE test_proc IS --test_proc存储过程名称
BEGIN
delete from xxx t where rownum < 100; --需要执行的sql语句
COMMIT;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Exception happened,data was rollback');
ROLLBACK;
END;
二、定制定时执行任务(在PL/SQL中使用“命令窗口”,每5分钟执行一次),"切记要提交事务""切记要提交事务""切记要提交事务"
var job_num number;
begin
dbms_job.submit(:job_num,'test_proc;',SYSDATE,'sysdate+5/24/60');
end;
/
三、查看任务状态