DB mail configuration ... setting retry attempts to zero

Question

DB mail configuration ... setting retry attempts to zero

dvprao

Ten Centuries

Points: 1311
More actions
January 23, 2017 at 5:41 pm

#318044

I set the retry to zero like this :
Can anyone confirm that this look ok ?
someone said it will keep retrying .
I could not get any link to that info.
AccountRetryAttempts 0 Number of retry attempts for a mail server
AccountRetryDelay 60 Delay between each retry attempt to mail server
DatabaseMailExeMinimumLifeTime 600 Minimum process lifetime in seconds
DefaultAttachmentEncodingMIMEDefault attachment encoding
LoggingLevel2Database Mail logging level: normal - 1, extended - 2 (default), verbose - 3
MaxFileSize1000000Default maximum file size
ProhibitedExtensionsexe,dll,vbs,jsExtensions not allowed in outgoing mails

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

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

Sue_H SSC Guru Points: 90860 More actions · Answer 1

dvprao - Monday, January 23, 2017 5:41 PM
I set the retry to zero like this :
Can anyone confirm that this look ok ?
someone said it will keep retrying .
I could not get any link to that info.
AccountRetryAttempts 0 Number of retry attempts for a mail server
AccountRetryDelay 60 Delay between each retry attempt to mail server
DatabaseMailExeMinimumLifeTime 600 Minimum process lifetime in seconds
DefaultAttachmentEncodingMIMEDefault attachment encoding
LoggingLevel2Database Mail logging level: normal - 1, extended - 2 (default), verbose - 3
MaxFileSize1000000Default maximum file size
ProhibitedExtensionsexe,dll,vbs,jsExtensions not allowed in outgoing mails

Yes that looks okay. In regards to the retry, it's an account retry. So if you have more than one account for a profile you are using, it's really how many attempts with each account before it moves on and tries the next account.

Sue

dvprao Ten Centuries Points: 1311 More actions · Answer 2

Sue_H - Monday, January 23, 2017 6:02 PM
dvprao - Monday, January 23, 2017 5:41 PM
I set the retry to zero like this :
Can anyone confirm that this look ok ?
someone said it will keep retrying .
I could not get any link to that info.
AccountRetryAttempts 0 Number of retry attempts for a mail server
AccountRetryDelay 60 Delay between each retry attempt to mail server
DatabaseMailExeMinimumLifeTime 600 Minimum process lifetime in seconds
DefaultAttachmentEncodingMIMEDefault attachment encoding
LoggingLevel2Database Mail logging level: normal - 1, extended - 2 (default), verbose - 3
MaxFileSize1000000Default maximum file size
ProhibitedExtensionsexe,dll,vbs,jsExtensions not allowed in outgoing mails
Yes that looks okay. In regards to the retry, it's an account retry. So if you have more than one account for a profile you are using, it's really how many attempts with each account before it moves on and tries the next account.
Sue

Thanks for the reply .
Oh. This is usually from an application profile .
Seem to send multiple emails with the same subject for a send attempt.
I am trying to stop that. If the first attempt fails , no re try .
so disable all public profiles ? and allow only one private profile for each account ?
( I hope I am not talking nonsense)

Sue_H SSC Guru Points: 90860 More actions · Answer 3

dvprao - Monday, January 23, 2017 6:09 PM
Thanks for the reply .
Oh. This is usually from an application profile .
Seem to send multiple emails with the same subject for a send attempt.
I am trying to stop that. If the first attempt fails , no re try .
so disable all public profiles ? and allow only one private profile for each account ?
( I hope I am not talking nonsense)

No worries...I understand what you are saying.
You don't need to mess with profiles if the application is just using one. For that profile the application is using, just limit it to one account for that profile. Then it won't move on to the next account and try that.
But it only would be re-sending if there are issues with the account and sending mail in the first place (like SMTP unreachable) so there could be something else going on.
You may want to check the sysmail_event_log table as if there are smtp errors or other errors, they should show up in there. You can filter that using something like:
select * from dbo.sysmail_event_log where event_type like 'error'
You might also want to query sysmail_allitems just to get an idea of what is going on with those mails.

Sue