I am trying to enable email notification through database mail on SQL server 2005. There are many jobs(100s) in the server. I am using sp_send_dbmail to send email to multiple email operators.
Could you kindly let me know if there is any way we could automate this process iteself. If I have to add a failure step to so many jobs it is so manual and time consuming. Is there any script or anything available which would make my task much easier.
I wouldn't be enabling operators for these jobs as I have issues with sending email to group emails. I would only be using sp_send_dbmail
Thanks for your help