Here is a script that gives you the list of operators name who receive notifications when a job fails
SELECT sysoperators.name AS JobName, sysjobs.name AS OperatorName, sysjobs.enabled, sysoperators.id
FROM sysjobs INNER JOIN
sysoperators ON sysjobs.notify_email_operator_id = sysoperators.id
You need to change the sysjobs.notify_email_operator_id to change the Notifications of the Operator.
Jun
16
2009
16
2009
