摘要: 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:ss'),interval = 'trunc(sysdate)+1+1/24',no_parse = FALSE);SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));COMMIT;END;/以上是明确指定每天的1点执行此job,如果指定是每天中午12 阅读全文