1 begin2 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;
本文共 323 字,大约阅读时间需要 1 分钟。
1 begin2 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;
转载于:https://www.cnblogs.com/lianghl/p/5218238.html