New Profile (Database Mail)
Use this page to create a Database Mail profile. A Database Mail profile is a collection of Database Mail accounts. Profiles improve reliability in cases where an e-mail server becomes unreachable, by providing alternative Database Mail accounts. At least one Database Mail account is required. For more information about setting the priority of Database Mail accounts in the profile, see Database Mail Profiles.
Note
Database Mail profiles are not related to SQL Mail profiles. Database Mail profiles are collections of SMTP accounts. SQL Mail profiles are MAPI profiles.
Use the Move Up and Move Down buttons to change the order in which Database Mail accounts are used. This order is determined by a value called the sequence number. Move Up lowers the sequence number and Move Down increases the sequence number. The sequence number determines the order in which Database Mail uses accounts in the profile. For a new e-mail message, Database Mail starts with the account that has the lowest sequence number. Should that account fail, Database Mail uses the account with the next highest sequence number, and so on until either Database Mail sends the message successfully, or the account with the highest sequence number fails. If the account with the highest sequence number fails, the Database Mail pauses attempts to send the mail for the amount of time configured in the Database Mail AccountRetryDelay parameter, then starts the process of attempting to send the mail again, starting with the lowest sequence number. Use the Database Mail AccountRetryAttempts parameter, to configure the number of times that the external mail process attempts to send the e-mail message using each account in the specified profile. You can configure the AccountRetryDelay and AccountRetryAttempts parameters on the Configure System Parameters page of the Database Mail Configuration Wizard.
Options
- Profile name
Type the name for the new profile. The profile is created with this name. Do not use the name of an existing profile.
- Description
Type a description for the profile. The description is optional.
- SMTP accounts
Choose one or more accounts for the profile. The priority sets the order in which Database Mail uses the accounts. If no accounts are listed, you must click Add to continue, and add a new SMTP account.
- Add
Add an account to the profile.
- Remove
Remove the selected account from the profile.
- Move Up
Increase the priority of the selected account.
- Move Down
Decrease the priority of the selected account.
See Also
Other Resources
Database Mail Accounts
sysmail_add_profile_sp (Transact-SQL)
sysmail_update_profile_sp (Transact-SQL)
sysmail_delete_profile_sp (Transact-SQL)