oracle作业


declare smyl_hxjob number;
begin
dbms_job.submit(smyl_hxjob,
'pro_autowriteoffToday_smyl;',
next_date => to_date('2019-07-09 00:00:00',
'yyyy-mm-dd hh24:mi:ss'),
interval =>'sysdate + 1');
COMMIT;
end;

posted @ 2019-07-17 14:40  MicrosoftMan  阅读(217)  评论(0编辑  收藏  举报