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
   )