begin
sys.dbms_job.submit(job => :job,
what => '你要执行的过程',
next_date => to_date('22-05-2005 16:50:41', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'TRUNC(SYSDATE)+15/(24*60)');
commit;
end;
/
sys.dbms_job.submit(job => :job,
what => '你要执行的过程',
next_date => to_date('22-05-2005 16:50:41', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'TRUNC(SYSDATE)+15/(24*60)');
commit;
end;
/
有关trunc(date) 的:
http://www.oracle.com.cn/onlinedoc/server.920/a96540/functions155a.htm#79763