{"id":804,"date":"2015-06-03T14:31:23","date_gmt":"2015-06-03T08:31:23","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=804"},"modified":"2015-06-29T16:48:32","modified_gmt":"2015-06-29T10:48:32","slug":"setup-sql-server-alerts-and-email","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/setup-sql-server-alerts-and-email\/","title":{"rendered":"Setup SQL Server alerts and email"},"content":{"rendered":"

Scenario<\/strong><\/p>\n

Setting up\u00a0an alert to e-mail an operator with a message is a multiple step process. You can setup database mail, define an operator and\u00a0an alert, but still no e-mail is\u00a0being sent. So how do you\u00a0send an alert to an operator?<\/p>\n

Solution<\/strong><\/p>\n

This solution involves restarting SQL Agent. <\/em><\/p>\n

Database Mail <\/strong><\/p>\n

First setup database mail with a profile named SQLAlerts. The profile can be named anything but in these instructions, the profile name SQLAlerts is referenced. If you wish to use a different profile name just substitute accordingly.<\/p>\n

Define Operator <\/strong><\/p>\n

Connect to the instance using Microsoft SQL Management Studio<\/p>\n

Double Click SQL Server Agent<\/p>\n

Right Click on Operators and select New Operator<\/p>\n

 
\nSpecify an operator Name, E-mail name, and click OK<\/p>\n

 <\/p>\n

Setup SQL Agent Settings <\/strong><\/p>\n

Note:<\/em><\/strong> This\u00a0step is often overlooked when creating an alert for the first time. SQL Agent must be setup correctly for operators to receive an\u00a0alert e-mail. <\/em><\/p>\n

Right Click SQL Server Agent > select Properties<\/p>\n

 <\/p>\n

Select Alert System in the left pane<\/p>\n