SQL Server – Add multiple email addresses for an operator

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. 

Adding multiple email addresses to SQL Server Operator

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

2 comments

Leave a Reply

Your email address will not be published. Required fields are marked *