declarejob_num number;iCount number;
BEGINselect count(1)into iCountfrom user_jobswhere what = '存储过程;';if iCount != 0 thenselect jobinto job_numfrom user_jobswhere what = '存储过程;';DBMS_JOB.remove(job_num);end if;DBMS_JOB.SUBMIT(JOB => job_num,WHAT => '存储过程;',NEXT_DATE => sysdate + 1,INTERVAL => 'TRUNC(sysdate+1)+3/24');commit;
end;
/每天凌晨3点运行