Oracle 9i沒有
DBMS_SCHEDULER可用, 只能用回
DBMS_JOBdeclare
????v_job_num?NUMBER;
begin
??dbms_job.submit(v_job_num,
??????????????????'test;',
??????????????????to_date(to_char(sysdate,?'yyyy-mm-dd')?||?'?23:59:00',?'yyyy-mm-dd?hh24:mi:ss'),
??????????????????'to_date(to_char(sysdate,?''yyyy-mm-dd'')?||?''?23:59:00'',?''yyyy-mm-dd?hh24:mi:ss'')?+?1');
??commit;
end;
/
參考: ora92_doc/server.920/a96521/jobq.htm#750
跟dbms_scheduler比起來, dbms_job有點弱智, 怪不得10g要放棄. in 10g, The DBMS_JOB package has been superseded by the DBMS_SCHEDULER package.