scheduler一直执行超过30分钟的作业监控
create or replace procedure sp_scheduler_check as
x number;
begin
select round((select (sysdate-(select to_date((select * from (select to_char(log_date,'YYYY-MM-DD HH24:MI:SS') from user_scheduler_job_run_details where job_name='XXX' order by log_id desc) where rownum<2),'YYYY-MM-DD HH24:MI:SS') from dual))*24*60 from dual),0) into x from dual;
if x>30 then
begin
SEND_EMAIL ('<ERP_admin@yuusei.cn>'
,'<luxus.liao@mic.com.tw;luxus.liao@mic.com.tw;horuse.yu@mic.com.tw>'
,'JIECHENG SCHEDULUER NEED CHECK >30'
,'JIECHENG SCHEDULUER NEED CHECK,SID.SEREAL SHOUD KILL');
end;
end if;
exception when others then
dbms_output.put_line(sqlcode);
rollback;
end;
x number;
begin
select round((select (sysdate-(select to_date((select * from (select to_char(log_date,'YYYY-MM-DD HH24:MI:SS') from user_scheduler_job_run_details where job_name='XXX' order by log_id desc) where rownum<2),'YYYY-MM-DD HH24:MI:SS') from dual))*24*60 from dual),0) into x from dual;
if x>30 then
begin
SEND_EMAIL ('<ERP_admin@yuusei.cn>'
,'<luxus.liao@mic.com.tw;luxus.liao@mic.com.tw;horuse.yu@mic.com.tw>'
,'JIECHENG SCHEDULUER NEED CHECK >30'
,'JIECHENG SCHEDULUER NEED CHECK,SID.SEREAL SHOUD KILL');
end;
end if;
exception when others then
dbms_output.put_line(sqlcode);
rollback;
end;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30126024/viewspace-2139886/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
listener监听监控脚本
请登录后发表评论
登录
全部评论
