Monitor : How to check sysmail / dbmail events or logging information.

All events from the dbmail send / receive mail notifications are logged in a sys table (sysmail_event_log) of msdb database.  We can easily track down the exceptions on mails sending & receiving from this table.

For example if an SMTP server throws an exception of sending email it will be logged as an error in the table 'sysmail_event_log'. Details below,

Query:

    
USE msdb
GO
SELECT * FROM sysmail_event_log WHERE log_date > '2015-04-29 10:00'
GO
    

Results:

Exception Message: 

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-04-29T10:36:34). Exception Message: Cannot send mails to mail server. (Insufficient system storage. The server response was: 4.3.1 Out of memory).)

Click here to redirect to msdn for more details on this.