Adding SQL Operators

Owned by Scott Pearce
Jul 16, 2018
2 min read

SQL Operators are special entities that receive notifications when various events occur on a SQL Server. Follow the steps below to configure SQL Operators:

  1. 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:




  2. Enter Name, email address, and ensure the "Enabled" checkbox is ticked.




  3. 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.