database mail queue not working

Question

Post reply

database mail queue not working

kailashIndia

SSC Eights!

Points: 935
More actions
January 20, 2016 at 4:13 am

#307177

Dear Sir,
kindly resolve my database mail below issue in SQL Server 2008.
database mail show in database mail queue (then "unsent") and not show in Database logs but same working fine before one week.
Thanks & Regards,
Kailash Singh,
M: 7827492235

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

SQL Severe DBA Hall of Fame Points: 3579 More actions · Answer 1

Few steps to start with .

What do you see in error when you run below query .

SELECT TOP 100 *

FROM msdb.dbo.sysmail_faileditems

ORDER BY last_mod_date DESC

SELECT TOP 100 *

FROM msdb.dbo.sysmail_event_log

ORDER BY last_mod_date DESC;

and check this table also : [msdb].[dbo].[sysmail_unsentitems]

kailashIndia SSC Eights! Points: 935 More actions · Answer 2

All mail show in table

[msdb].[dbo].[sysmail_unsentitems]

Please guide what is issue.

lsalih SSCertifiable Points: 6143 More actions · Answer 3

Here is a good link to troubleshoot, https://technet.microsoft.com/en-us/library/ms187540(v=sql.105).aspx

Try to restart it and see.

Also are you using more than one profile? If so, go to database mail and send test Email using different profiles. That seems to clear the queue if the database mail crashes.

kailashIndia SSC Eights! Points: 935 More actions · Answer 4

I have try all option but still not working but working fine in SQL Server latest version 2012 and above Not working in SQL Server 2008 R2. Plz guide.

kailashIndia SSC Eights! Points: 935 More actions · Answer 5

I have try all option but still not working but working in SQL Server latest version 2012 and above

Plz guide.

lsalih SSCertifiable Points: 6143 More actions · Answer 6

One thing you can do is generate the script of the mail profile which works in 2012, and use the code to create it the same thing in 2008 and see if that works.

What error are you getting in the log? SELECT * FROM msdb.dbo.sysmail_event_log;

check if mail is enabled, etc.? You must see some error if there is an issue.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

The first thing I would do is to check which SMTP server you're pointing to. If it's not up and running, all mail is going to fail.

The log will contain a description of the errors for each email you've attempted to send. They'll likely guide you to the cause of the problem.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions