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
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步