Oracle 9i没有
DBMS_SCHEDULER可用, 只能用回
DBMS_JOB
参考: 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.
declare
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 ;
/
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.