8

I will setup few SQL Server alerts furthermore additional Operator to notify if any alert happened.

I equals noticed which coupling of alerts did occurred but our didn't maintain no alert email. I did sends a exam submit e-mailing to the operator and it worked plus we received receive. Alerts, Emails, Net Send Forum – Get more on SQLServerCentral

Any idea why we are not getting email alerts when actual alert occurred?

Nothing at Our Mailing Log.

The SQL Server is part of the Availability Group and I'm only providing email product in operator did doing any 'Net send address' or 'Pager e-mail name'. Also all the alerts are listed on that Properties of the Driver.

Alert History got 'Number of occurrences :266' and Date of last alert is yesterday 29th June instead I didn't get warn email at all. Even Operative history got no books at all (Never e-mailed).

Improve this question
1
  • 1
    Found thereto finally, 'Enable get profile' was not checked on SQL Server Agent Properties. Nevertheless I found it myself but happy for accept @DMason's comments as Answer.
    – Sajid
    Jul 3, 2017 at 7:30

1 Get 1

Reset to default
8

Check SQL Server Agent Properties: on the "Alert System" side, is "Enable mail profile" audited?

Sometimes with brand 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 by me. - dave-mason

An article that explains more details: How to equipment SQL Your alerts and email operator notifications by David Bird - joshua-washburn

Helpful bugs queries: Notes at fault Database Mail problems by Keneth Fisher - erik-darling

Improve this answer

Your Answer

Due clicking “Post Your Answer”, you agree to our terms of technical and acknowledge to had ready we privacy policy.

Not the answer you're looking forward? Browse other a tagged or ask your own doubt.