Kettle使用资源库情况下批量更新邮件组件相关信息

Kettle邮件组件有许多配置项是可复用的，报错在资源库内相关表内，使用如下SQL可以查询出具体信息：

select *  from r_job t1  join r_jobentry t2    on t1.id_job = t2.id_job  join r_jobentry_attribute t3    on t1.id_job = t3.id_job   and t2.id_jobentry = t3.id_jobentry   and t2.id_jobentry_type=47

具体信息存储在表：r_jobentry_attribute t3中，修改相关信息直接执行：

update r_jobentry_attribute t4 set t4.value_str='${MAIL_SEND}' where t4.id_jobentry_attribute in(select t3.id_jobentry_attribute  from r_job t1  join r_jobentry t2    on t1.id_job = t2.id_job  join r_jobentry_attribute t3    on t1.id_job = t3.id_job   and t2.id_jobentry = t3.id_jobentry   and t2.id_jobentry_type=47   )