Sunday, August 25, 2013

[MS SQL Server] Database Mail not sending emails

[MS SQL Server] Database Mail not sending emails


Database Mail not sending emails

Posted: 24 Aug 2013 11:05 AM PDT

Hi,I am not able to send emails using database mail. can you please help me in fixing the issue.Server : SQL SERVER 2008 R2 Enterprise Edition (64-bit) Windows: Windows SERVER 2008 R2 Standard Edition (64-bit) SP1 I can see database mail started. I can see after feb 25,2013 the database emails stopped being getting delivered.I am not posting columns from 17 to 233 under mailitem_id in email sent status as it would make the post larger. the data looks similar.Mail Queuesqueue_type length state last_empty_rowset_time last_activated_timemail 228 INACTIVE 2013-08-24 20:22:12.787 2013-08-24 20:22:12.773status 0 INACTIVE 2013-06-10 14:28:32.893 2013-06-10 14:28:32.893--Email Sent Statusmailitem_id profile_id send_request_date sent_account_id sent_status sent_date last_mod_date1 1 2/11/13 11:07 AM 1 sent 2/11/13 11:07 AM 2/11/13 11:07 AM2 1 2/11/13 11:11 AM 1 sent 2/11/13 11:11 AM 2/11/13 11:11 AM3 1 2/19/13 8:00 AM 1 sent 2/19/13 8:00 AM 2/19/13 8:00 AM4 1 2/25/13 11:23 AM 1 sent 2/25/13 11:23 AM 2/25/13 11:23 AM5 1 2/25/13 11:23 AM 1 sent 2/25/13 11:23 AM 2/25/13 11:23 AM6 1 2/25/13 1:51 PM 1 sent 2/25/13 1:51 PM 2/25/13 1:51 PM7 1 2/25/13 1:55 PM 1 sent 2/25/13 1:55 PM 2/25/13 1:55 PM8 1 2/25/13 2:03 PM 1 sent 2/25/13 2:03 PM 2/25/13 2:03 PM9 1 2/25/13 2:06 PM 1 sent 2/25/13 2:06 PM 2/25/13 2:06 PM10 1 6/25/13 7:00 AM NULL unsent NULL 6/25/13 7:00 AM11 1 6/25/13 7:15 AM NULL unsent NULL 6/25/13 7:15 AM12 1 6/26/13 7:00 AM NULL unsent NULL 6/26/13 7:00 AM13 1 7/8/13 9:00 AM NULL unsent NULL 7/8/13 9:00 AM14 1 7/10/13 7:00 AM NULL unsent NULL 7/10/13 7:00 AM15 1 7/12/13 10:00 AM NULL unsent NULL 7/12/13 10:00 AM16 1 7/12/13 10:04 AM NULL unsent NULL 7/12/13 10:04 AM234 1 8/24/13 6:39 AM NULL unsent NULL 8/24/13 6:39 AM235 1 8/24/13 6:54 AM NULL unsent NULL 8/24/13 6:54 AM236 1 8/24/13 7:09 AM NULL unsent NULL 8/24/13 7:09 AM237 1 8/24/13 4:22 PM NULL unsent NULL 8/24/13 4:22 PMThank You,

No comments:

Post a Comment

Search This Blog