oracle-job(定时每天0点五分执行一个存储过程)

 

begin

  sys.dbms_job.submit(job => :job,

                      what => 'ccs_job_order_daystat;',

                      next_date => to_date('11-09-2010 00:05:00', 'dd-mm-yyyy hh24:mi:ss'),

                      interval => 'trunc(sysdate+1)+5/(24*60)');

  commit;

end;

/