Oracle如何定时启动job

1 begin
2   sys.dbms_job.submit(job => :job,
3                       what => 'P_customer_entry_time;',
4                       next_date => to_date('2009-08-15 22:00:00', 'yyyy-mm-dd 24HH:MI:SS'),
5                       interval => 'trunc(sysdate+1)+22/24');
6   commit;
7 end;

 

posted on 2016-02-25 20:30  梁海利  阅读(656)  评论(0编辑  收藏  举报