Question: Is it possible to setup a notification email being sent to multiple operators for that specific job?
I don’t believe this is possible.
Certainly looking at the structure of [msdb].[dbo].[sysjobs]
the various operator_id
columns are in this table itself which would support the idea that 1 to many is not possible.
But some alternatives
- 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 innvarchar(100)
- if you need to exceed that you could probably set up an email distribution group on exchange or whatever.