Oracle定时器,一旦设置,服务器的重启不会影响Oracle定时器的履行(定时每天履行),
begin
sys.dbms_job.submit(job => :job,
what => "check_err;",
next_date => trunc(sysdate)+23/24,
interval => "trunc(next_day(sysdate,""星期五""))+23/24");
commit;
end;
beg