We have to use personal credentials and secure connection in the automations email settings for scheduled automations. Each year we have to change our password; is there a way to change the email settings for a years worth of designed automations en-masse?
I can think of a bad way. Use a variable that reads in the passwords from a table, then just update the table once a year/quarter/etc. However storing passwords is generally a bad idea unless they are encrypted (well encrypted). Better is to use a service account for all scheduled jobs, that way it is the same change for all jobs. Sorry I can’t be more helpful.
The Find and replace in files works very well in Toad. All automation scripts are xml so finding the correct item to find and replace should be easy.