xmanman

导航

 

DECLARE
X NUMBER;
begin
sys.dbms_job.submit(job => x,
what => 'begin
dd_income_risk_control;
end;',
next_date => to_date('18-10-2016 15:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate)+1+15/24');
commit;
end;

 

每日的15点准时运行

posted on 2016-10-19 09:38  xmanman  阅读(682)  评论(0)    收藏  举报