DBMail Timeout resulting in resends

Question

DBMail Timeout resulting in resends

TroyG

SSCrazy

Points: 2633
More actions
July 17, 2012 at 4:46 pm

#261393

Hi,
I have done a quick search however not come up with anything helpful - although I don't profess to be the worlds best searcher (my Mum will attest to that :-P)
Anyhow; we have dbmail setup and usually works fine. However occaoccasionallym getting messmessagesthe log that say :
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2012-07-17T13:25:55). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
This in itself is manageable, however the issue that we have is that even though there are timeouts for the given mail message, each message does actually go through to the Exchange server - so it ends up meaning that the recipient gets multiple instances of the emails.
email't see any timeout duration flag that I can set....
does anyone have any ideas that might help me track down the cause and possibly a resolution to this?
Much appreciated
Regards
Troy

Viewing 3 posts - 1 through 2 (of 2 total)

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

halfarm35 Valued Member Points: 73 More actions · Answer 1

Hi Troy,

Perhaps the exchange server is not responding in time (I heard you were processing a large batch of around 10 emails - perhaps this is overloading your exchange server?).

You can increase the timeout, take a look at the following article:

http://support.microsoft.com/kb/968834

Thanks,

Kyle

TroyG SSCrazy Points: 2633 More actions · Answer 2

Thanks for the response Kyle

One thing I ommitted to mentioning in my intial post was the version that we are currently running:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)

From what I can tell the link you post is for a cumulative update for SQL 2005 up to 2008 Sp1 and would have expected this functionality to be included in the R2 release; but looking at the stored proc it mentions (in my installation) I cannot see a switch to pass in a specific timeout value. I am not 100% confident that this is either for our version or will give me the functionality I am after.

Any thoughts on this?

I will have a hunt around for something for R2 specifically, but failing that try it on a stand alone test bed.

Thanks again for the post.

Regards

Troy