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