oracle作业

declare job number;BEGIN            SYS.DBMS_JOB.SUBMIT            ( job =>job               ,what => 'procedurename;'               ,next_date => to_date(to_char(sysdate+1,'yyyy-mm-dd')||'01:00:00','yyyy-mm-dd hh24:mi:ss'),               ,interval => 'trunc(sysdate+1)+(1/24)'               ,no_parse => FALSE            );

?每天凌晨1点执行procedurename存储过程

我的异常网推荐解决方案：oracle存储过程,http://www.myexception.cn/oracle-develop/177537.html