Oracle Timer instance, timer Helloword

The following is a practical use of the timer in the work, add some comments posted.

Simple four steps, you can use the copy directly.

--Create a stored procedure create or replace Procedure Pro_nianjia is the Begin update bo_ehr_archive set kxnjxss= (Floor ((sysdate-indate)/36  5)-1) *8 +40 where sysdate-indate>360 and To_char (indate, ' Mmdd ') =to_char (sysdate, ' mmdd ');   Commit; End; --timed daily execution of defined stored procedures variable Nianjia_timer number; Begindbms_job.submit (: Nianjia_timer, ' Pro_nianjia; ', sysdate, ' sysdate+1 '); Commit; end;--View the timer in execution select Job,next_date,next_sec,failures,broken from User_jobs; --Delete timer begindbms_job.remove (54); Commit; End;

This article is from the "coder-technology sharing" blog, please be sure to keep this source http://viphyy.blog.51cto.com/6403455/1600264

Oracle Timer instance, timer Helloword