'Replace All references to email Pentaho Jobs error checking in Repository

I have over 100 jobs (kjb) that reference an email address that is no longer active. I wish to globally change the email address dynamically using PDI (spoon) in all jobs.

The jobs are in XML and are in a Pentaho Repository (Windows Server).

the code I wish to change in all jobs is:

  <destination>bubba</destination>
  <destinationCc/>
  <destinationBCc/>
  <replyto>[email protected]</replyto>
  <replytoname>Bubba</replytoname>

To:

  <destination>${EMAIL_ERROR_LIST}</destination>
  <destinationCc/>
  <destinationBCc/>
  <replyto>[email protected]</replyto>
  <replytoname>admin</replytoname>

do we really need to make changes and then individually promote everything back to production, or could we somehow do this with a transformation dynamically?

Solution 1:^[1]

this is not a solution in PDI, but you can open all XML files (jobs) with text editor and searh the field you want to change by the other value.

The same thing in a repository, but you can searh in table for the specific jobs.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	DeathX

'Replace All references to email Pentaho Jobs error checking in Repository

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]