Show list of SQL Server Agent operators in a query

Question

How can I see (with a query) the list of operators of SQL Server Agent with their e-mail address?

I am asking it because i want to put more than one e-mail address and I used the msdb.dbo.sp_update_operator construct as described here, but unfortunally I can use only 100 characters so I want to check if the were a truncation.

How many Email addresses you are trying to insert and length — Ven, Feb 15 '18 at 10:45

score 2 · Accepted Answer · edited Feb 26 '20 at 23:25

2

You can get, through the following query, all of the operators email addresses, along with a lot of other potentially useful information.

SELECT * 
FROM [msdb].[dbo].[sysoperators]

edited Feb 26 '20 at 23:25

LarryF

4,925
4
32
40

answered Aug 06 '18 at 09:48

Mitul Panchal

592
5
7

4

The correct query is SELECT * FROM msdb.dbo.sysoperators – Nicolaesse Aug 20 '18 at 07:18

Show list of SQL Server Agent operators in a query

1 Answers1