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.
Yesterday Afternoon me and my friend were doing some serious Sql manipulation on some heavy datasets that needs to go inside the Cube.We have written some dynamic SQL statement that is going to insert some 40000 rows into a Control table for a Dimension. Weird Enough my friend accidently closed the Query window and for [...]
