Select Page

Quick Scan Report – Failed Database Mail

If your SQL Server is attempting to send database mail, and the send process fails, it may not be entirely obvious that the mail failed.

You can use the following query to see what mail has been sent, or has been attempted to be sent from your SQL Server;


SELECT * 
 FROM msdb.dbo.sysmail_allitems WITH (NOLOCK);


 

The Quick Scan Report detects Failed Database Mail.

 

Related Links: