Oracle job

发表于 由
  1. begin  
  2.   sys.dbms_job.submit(job => :job,   
  3.                       what => 'PROC_OPTIMIZEDATA(''7'');',   
  4.                       next_date => to_date('16-05-2009 01:00:00', 'dd-mm-yyyy hh24:mi:ss'),   
  5.                       interval => 'trunc(sysdate)+1+1/24');   
  6.   commit;   
  7. end;   
  8. /   
  1. da shang
    donate-alipay
               donate-weixin weixinpay

发表评论↓↓