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.aiyiweb.com/oracle-develop/177537.html