Oracle定时器实例，定时器helloword-Coder随手记
--建立一个存储过程Create or replace Procedure pro_nianjia
Is
Begin
update bo_ehr_archive set kxnjxss=((floor((sysdate-indate)/365)-1)*8)+40 where sysdate-indate>360 and to_char(indate,'mmdd')=to_char(sysdate,'mmdd');
Commit;
End;
--定时每天执行已定义的存储过程
variable nianjia_timer number;
Begin
Dbms_Job.Submit(:nianjia_timer,'pro_nianjia;',Sysdate,'sysdate+1');
Commit;
End;
--查看在执行的定时器
select job,next_date,next_sec,failures,broken from user_jobs;
--删除定时器
Begin
dbms_job.remove(54);
Commit;
End;
页:
[1]