SQL Server - Add multiple email addresses for an operator

by Administrator 10. November 2009 00:00

SQLServer Agent Jobs can only have one operator defined under the notifications section so what do you do if you want to send notification emails to more than one person? You could set up a distribution list within your email system but a simpler approach is simply to semi-colon separate the list of email addresses. 

Its as simple as that ! Just make sure you have enabled your alerting for the SQL Server Agent and configured database correctly and away you go

 

 


Buy Me a Beer ?

If you've found this site useful, you could help support its running costs by either checking out the adverts on the page if you find anything that interests you - or by making a small donation