sql建JOB语句

declare
job_id pls_integer;
begin
sys.dbms_job.submit(job => job_id,
what => 'proc_AGTAWBSTATISTIC;',
next_date => to_date('21-10-2016 03:16:25', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1');
commit;
end;
/

posted @ 2016-10-20 14:05  Note Down  阅读(1202)  评论(0)    收藏  举报