Adding SQL Operators
- Scott Pearce
Analytics
SQL Operators are special entities that receive notifications when various events occur on a SQL Server. Follow the steps below to configure SQL Operators:
In Microsoft SQL Server Management Studio, connect to the SQL Server as the sa user (or a similarly privileged user). In the left hand pane expand the SQL Server node, followed by the "SQL Server Agent" node that appears underneath. Right-click on "Operators" and click the "New Operator..." option:
Enter Name, email address, and ensure the "Enabled" checkbox is ticked.
Click "OK" to create the SQL Operator. The SQL Operator should now appear under the "Operators" node:
SQL Operators can be selected to receive notifications when certain events occur in SQL Server, such as a SQL Server Agent job succeeding, or failing.