I have setup few SQL Server alerts and added Operator to notify if any alert occurred. I just noticed that couple of alerts did occurred but we didn't receive any alert email. I did send a test notification email to the operator and it worked and we received email. Just wondering any idea why we are not getting email alerts when actual alert occurred. Thanks in advance.

  • What do you see in your Database mail log? – SqlWorldWide Jun 29 '17 at 14:32
  • On the Properties of your Operator, is the Alert listed on the Notifications tab? – tpet Jun 29 '17 at 14:32
  • 1
    Try running something like RAISERROR('Test', 18, 1) WITH LOG -- replace the 18 with whatever error severity you're trying to alert on. Check out this blog for helpful debugging queries: sqlstudies.com/2013/07/29/… – Erik Darling Jun 29 '17 at 14:33
  • 4
    Check SQL Server Agent Properties: on the "Alert System" page, is "Enable mail profile" checked? Sometimes with new installations, after I set up options on that page I've found notification emails for alerts aren't sent. A restart of the SQL Agent service often addresses that issue for me. – Dave Mason Jun 30 '17 at 15:50
  • 1
    Found it finally, 'Enable mail profile' was not checked on SQL Server Agent Properties. Though I found it myself but happy to accept @DMason's comments as Answer. – Sajid Jul 3 '17 at 7:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.