12

oracle job案例

2014-05-03 16:45:00    1147533288    1947    原创
declare
job number;
begin
  sys.dbms_job.submit(job => job,what => 'declare prm_AppCode NUMBER(10);prm_ErrMsg VARCHAR2(2000); begin pkg_task.prc(prm_AppCode,prm_ErrMsg);end;',next_date => sysdate,interval => 'sysdate+1/24/12');
  commit;
end;
/
© Design by Meepo
苏ICP备18038013号-1
蝉知 蝉知5.2