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!