What Table(s) Store the DBMAIL Info

• JC-3113

  SSCrazy Eights

  Points: 8371

  More actions

  September 16, 2010 at 3:09 pm

  #224080

  Hi Folks

  when using: EXEC msdb.dbo.sp_send_dbmail

  it says "Mail queued"

  Can someone tell me where that info is stored and where i can find the status on the mail sent?

  Thanks

  Jim

• jjtetzlo

  SSCrazy

  Points: 2511

  More actions

  September 16, 2010 at 3:20 pm

  #1222654

  What you're looking for is sysmail_allitems.

  select * from msdb.dbo.sysmail_allitems

  Here's a reference: http://msdn.microsoft.com/en-us/library/ms191278(v=SQL.90).aspx

  - Jeff

• JC-3113

  SSCrazy Eights

  Points: 8371

  More actions

  September 16, 2010 at 3:21 pm

  #1222656

  Thanks Jeff

  will take a look

  Jim

• WayneS

  SSC Guru

  Points: 95460

  More actions

  September 16, 2010 at 3:48 pm

  #1222672

  there are also:

  dbo.sysmail_faileditems

  dbo.sysmail_sentitems

  dbo.sysmail_unsentitems

  Umm... can you guess what they might be showing?

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• JC-3113

  SSCrazy Eights

  Points: 8371

  More actions

  September 16, 2010 at 4:13 pm

  #1222678

  Thanks WayneS

  Jim