Oracle job 执行多个存储过程

job_action          => 'declare
       sretvalue varchar2(10);
     begin
       easytong.up_gxxx_xqjbsjzl(sRetValue => sretvalue);
       easytong.up_gxxx_yxsdwjbsjzl(sRetValue => sretvalue);
       easytong.up_gxjx_zyxxsjlb(sRetValue => sretvalue);
       easytong.up_gxxx_bjsjlb(sRetValue => sretvalue);
       easytong.up_gxxs_xsjbsjzl(sRetValue => sretvalue);
       easytong.up_gxxs_xjjbsjzlb(sRetValue => sretvalue);
       easytong.up_gxjg_jzgjcsjzlb(sRetValue => sretvalue);
     end;',

 

删除所有JOB产生的LOG：

   exec dbms_scheduler.purge_log;

 

--另外参考：http://www.xifenfei.com/2011/12/dbms_scheduler%E5%B8%B8%E8%A7%84%E6%93%8D%E4%BD%9C.html