We help IT Professionals succeed at work.
Get Started

Some SQL Server Agent alerts are getting missed completely by Sysmail / DBmail

171 Views
Last Modified: 2018-10-15
Hello,

I have configured SQL Server Agent alerts to send emails when they are raised, among them is a "SQL Server event alert" for Severity "016 - Miscellaneous User Error".

I have set the "Response" of the alert to email two operators, and in "Options" I have selected to include alert error text in "E-mail".

The problem is that this alert is working for the most part.

I run scheduled differential backups overnight for 51 databases and usually a handful will fail due to insufficient disk space on the backup server (error 112).  If there are 5 such failures, I will receive anywhere from 3-5 emails, with no predictability.

I questioned if it was my email server which was not working 100%, but after querying [msdb].[dbo].[sysmail_allitems] there is actually no mention of the missing alert email.  The ones I did receive are there, but not the missing one.  It is also not there in [msdb].[dbo].[sysmail_faileditems] or any of the other sysmail views, for that matter.

However, in the Windows Event Viewer, the "missing" alert and all the alerts for "Severity 016" are there like they should be.

I am running SQL Server 2014 Developer, build 12.0.5589.7 (SP2 CU12).

Any help will be greatly appreciated!
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE