Search code examples
sql-serversp-send-dbmail

meaning of the values of sent_status on msdb.dbo.sysmail_mailitems

I am sending emails from SQL Server, and need to map the values of the sent_status column on the msdb.dbo.sysmail_mailitems table to something more descriptive.

So far I have identified two values:

  • 1 = 'Sent'
  • 2 = 'Failed'

Are there any more possible values, and if so what do they represent?

Solution 
  • sent_status, --0 new, not sent, 1 sent, 2 failure or 3 retry.