DB mail configuration ... setting retry attempts to zero

  • 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

  • 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

  • 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)

  • 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

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

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