KETTLE监控 - 月饼馅饺子 - 博客园
- -kettle单实例环境下自身没有监控工具,但在集群下自带了监控工具. kettle自带的集群监控工具可以监控转换的执行情况. 配置好集群后,打开浏览器:输入 http://localhost:8080,输入子服务器的用户名和密码. 进入后,点击show status:. 点击转换名称可以看到转换的详情:.
select id_job,name from kettle_res.r_job a ;
select distinct a.id_job,a.name job_name,b.name trans_name,c.status trans_status,c.LOGDATE laste_exec_time
from kettle_res.r_job a left join kettle_res.r_jobentry b on a.id_job=b.id_job and b.id_jobentry_type=87
left join test.trans_logs c on b.name=SUBSTRING_INDEX(c.transname,'(',1)
and c.logdate= (select max(logdate) from test.trans_logs d where SUBSTRING_INDEX(d.transname,'(',1) =SUBSTRING_INDEX(c.transname,'(',1) group by SUBSTRING_INDEX(d.transname,'(',1) )
group by a.name order by a.id_job,b.id_jobentry