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:


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
Last modified: November 6, 2020



Write a Reply or Comment