Scenario

Setting up an alert to e-mail an operator with a message is a multiple step process. You can setup database mail, define an operator and an alert, but still no e-mail is being sent. So how do you send an alert to an operator?

Solution

This solution involves restarting SQL Agent. Continue reading Setup SQL Server alerts and email →