Search code examples
sqlsql-serversql-server-agent

Show list of SQL Server Agent operators in a query

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.

Solution

  • 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]