日期:2014-05-16 浏览次数:20471 次
DECLARE job NUMBER; begin sys.dbms_job.submit(job => :job, what => 'pro_syn_date_d;', next_date => to_date('30-04-2014 08:15:35', 'dd-mm-yyyy hh24:mi:ss'), interval => 'trunc(sysdate+1)+(08*60+15)/(24*60)'); commit; end; /
DECLARE job NUMBER; begin sys.dbms_job.submit(job => job, --注意:此处没有冒号 what => 'pro_syn_date_d;', next_date => to_date('30-04-2014 08:15:35', 'dd-mm-yyyy hh24:mi:ss'), interval => 'trunc(sysdate+1)+(08*60+15)/(24*60)'); commit; end;