Operators and E-mail addresses

[mutley1]

Hi All,

I know strictly speaking this is a Setup & Admin question, but I am not aware of an SP that exists to retrieve the info so I was wondering if any programmers had written something.

Is there something I can run to retrieve the operators from SQL Agent and the email addresses that are set for that SQL Agent Operator?

Cheers,

M.

 

[mrdenny]

Provided by Microsoft and installed on all SQL Servers.

exec sp_help_operator

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mutley1]

Thanks Denny,

I think I was having a bad day. I remember it now but couldn't see the wood for the trees

Thanks again,

M.