Create Operator From Script

No Pager schedule.

USE [msdb]

EXEC msdb.dbo.sp_add_operator @name=N'DBA', 

Multiple Email Addresses:

Add multiple email addresses separate by semi colon “;”

E-mail name:;

  1. You could create a new operator with the semi colon delimited list of email addresses. Looking at the definition of sysoperators this is good for strings that can fit in nvarchar(100)
  2. If you need to exceed that you could probably set up an email distribution group.

Last modified: July 24, 2020



Write a Reply or Comment