Database Mail takes hours to delivier email

Question

Database Mail takes hours to delivier email

WayneS

SSC Guru

Points: 95460
More actions
November 3, 2008 at 7:47 am

#383285

I've set up Database Mail on my development server to test it out.
When I fire off a job that sends an email, I won't get the email for several hours - though I always eventually do get it.
Any ideas of what I should look at to resolve this problem?
Thanks,
Wayne
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

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

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

Mark Sumner SSCommitted Points: 1851 More actions · Answer 1

I'd be looking at the email / relay server. Once database mail is configured properly and working it's usually fine. Have you tried sending a test email from the GUI? (Right click database mail and send test email). That way you can rule out any issue with whatever job it is you are emailing from..

krayknot SSCertifiable Points: 7998 More actions · Answer 2

WayneS (11/3/2008)
I've set up Database Mail on my development server to test it out.
When I fire off a job that sends an email, I won't get the email for several hours - though I always eventually do get it.
Any ideas of what I should look at to resolve this problem?
Thanks,
Wayne

It only depends on the server and the internet connection type you are using.

kshitij kumar
kshitij@krayknot.com
www.krayknot.com

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

You can see the log by using following command:

SELECT * FROM msdb.dbo.sysmail_event_log

See the mail has been delivered by SQL Database Mail on time? Probably you can take it from here.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

WayneS SSC Guru Points: 95460 More actions · Answer 4

Interesting. While testing out the select statement above, I am getting the emails almost instantly. Typical.

The logs were showing the database mail process starting, and about 10 minutes later stopping.

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

Mark Sumner SSCommitted Points: 1851 More actions · Answer 5

The logs were showing the database mail process starting, and about 10 minutes later stopping.

Mine is no different. i think that is expected behaviour. Sounds like your Database mail is configured just fine.

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 6

I get the same thing..........over here - i am on with MS but they can't figure out but the call is still open.

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 7

10 MIN is the default then it stops the databasemail then it should fire again when you request email.

You can change this setting but mine sometimes fires on the hour then four hours later i get the catch up emails. Some days it works fine its strange for me.