1. 创建JOB
begin
sys.dbms_job.submit(job => :job,
what => 'USER_ABC.PRC_SYNINFO;',
next_date => to_date('12-02-2009 16:41:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'TRUNC(SYSDATE,''MI'') + 40/ (24*60)');
commit;
end;
ORACLE 程序员开发笔记
最新推荐文章于 2019-07-11 13:57:48 发布