SQL Server Agent – Operators Multiple Email

When a job fails, you have set to have it alert an operator.

For the operator setting, you can add multiple email address to the “E-mail name” field separated by semicolon.

E-mail name:

John.Doe@MyCompany.com;Jane.Doe@MyCompany.com

Edit via script…

EXECUTE msdb.dbo.sp_update_operator
  @name = N'JobWatcher',
  @email_address = N'person1@company.org;person2@company.org';

Note: There is a 100 character limit. It is set in the sysoperators table. DO NOT try to ALTER the email_address column. This will break the GUI.

 SELECT * FROM sysoperators