oracle 定时任务job

 oracle 定时任务job

begin
  sys.dbms_job.submit(job => :job,
                      what => 'p_back_delhisreportjob;',
                      next_date => to_date('06-09-2007 04:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'trunc(sysdate +1, ''dd'') + 4/24');
  commit;
end;