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

sql-server sp-send-dbmail
patovega picture patovega · Nov 18, 2014 · Viewed 26.3k times · Source

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?

Answer

sunysen picture sunysen · Nov 18, 2014 
sent_status, --0 new, not sent, 1 sent, 2 failure or 3 retry.

Related questions

How to send email from SQL Server?

How can I send an email using T-SQL but email address is stored in a table? I want to loop through the table and be able to send email. I cannot find a good example of doing this so far.

Read More
'profile name is not valid' error when executing the sp_send_dbmail command

I have a windows account with users group and trying to exec sp_send_dbmail but getting an error: profile name is not valid. However, when I logged in as administrator and execute the sp_send_dbmail, it managed to …

Read More
sp_send_dbmail executed from job fails with query result attached as file

I have faced with the following issue: when trying to send email with results of query attached as file, using sp_send_dbmail via executing ordinary query everything seems to be working OK. But if add the same code into …

Read More