Toad World® Forums

possible to change email serving setting in automations en-masse


#1

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?


#2

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.


#3

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.