Change Alert Email Addresses through SQL

Some of my customers are changing their email addresses. I have over 1000 alerts which need their email addresses changed. Not all alerts list customer's name in the header so I'm not 100% sure who receives each email unless I open a specific alert and look at email addresses.  

Is there a way to change the email addresses for the alerts through the database? Specifically, can I do a job or something like a "Find fred.loucks@yahoo.com and Replace With fred.loucks@gmail.com." I would like to do a bulk change/bulk changes for each entity that is changing their email address. Is that possible? If so, what commands and process would I use to make that happen?

Parents
  • Yes, although if you don't know how to do a sql replace yourself I'd be extremely nervous about trying to explain it to you via a forum.   There are lots of tiny syntax mistakes that are silly easy to make when doing a table update. 

    If there is a DBA at your company that can back the db up with you and run through ithe change with you then it's really going to do a lot to keep you from accidentally messing up all of your alert configurations and having to do a panic db restore

Reply
  • Yes, although if you don't know how to do a sql replace yourself I'd be extremely nervous about trying to explain it to you via a forum.   There are lots of tiny syntax mistakes that are silly easy to make when doing a table update. 

    If there is a DBA at your company that can back the db up with you and run through ithe change with you then it's really going to do a lot to keep you from accidentally messing up all of your alert configurations and having to do a panic db restore

Children
No Data