Which SQL Server Agent operator has which mail id's
The below query will tell you which SQL Server Agent Operator is internally calling which mail id's. These operators we can assign to every sql server agent job. So whenever these jobs gets failed it will route to those mail id's
GO
EXEC dbo.sp_help_operator
@operator_name = N'Provide Operator name here';
Comments