Oracle Job

Oracle Job

//每天九点过一秒执行'dps.silo_history_recored一次      9/24 小时转化成天  1/86400 秒转
begin
  sys.dbms_job.change(job => 141,                                  --JobNum
                      what => 'dps.silo_history_recored;',            --ProcedureName
                      next_date => to_date('11-07-2006 09:41:14', 'dd-mm-yyyy hh24:mi:ss'), --Sysdate
                      interval => 'trunc(SYSDATE)+9/24+1/86400');        --9 :the hour of  interval
                                                                                                      --1/86400 the second of interval
  commit;
end;