每天1点执行的oracle JOB样例

canca16年前 (2010-07-16)593
DECLAREX NUMBER;BEGINSYS.DBMS_JOB.SUBMIT( job => X,what => 'ETL_RUN_D_Date;',next_date => to_date('2009-08-26 01:00:00','yyyy-mm-dd hh24:mi:s…