如何用sql语句写一个定时完成的任务的job

Question

如题所述

Answer 1

采用存储过程来实现，在job中调用此存储过程。
create or replace procedure delete_proc
as
begin
execute immediate 'delete from pm_time_rule t where t.special_end_time < sysdate and t.activeflag=0';
end;
/

declare
varable job number;
begin
dbms_job.submit(:job,'delete_proc;',sysdate,'trunc(sysdate+1)');
commit;
end;
/