var jobno number
begin
sys.dbms_job.submit(job => :jobno,
what => 'p_report_bb_install;',
next_date => to_date('05-09-2007', 'dd-mm-yyyy'),
interval => 'TRUNC(SYSDATE)+1');
commit;
end;
/
posted on 2007-09-04 17:42
xzc 閱讀(252)
評論(2) 編輯 收藏 所屬分類:
Oracle