This topic has not yet been rated - Rate this topic

sysmail_configure_sp (Transact-SQL)

SQL Server 2008 R2

Changes configuration settings for Database Mail. The configuration settings specified with sysmail_configure_sp apply to the entire SQL Server instance.

Topic link icon Transact-SQL Syntax Conventions

Syntax

sysmail_configure_sp [ [ @parameter_name = ] 'parameter_name' ]
    [ , [ @parameter_value = ] 'parameter_value' ]
    [ , [ @description = ] 'description' ]

Arguments

[@parameter_name = ] 'parameter_name': The name of the parameter to change.
[@parameter_value = ] 'parameter_value': The new value of the parameter.
[@description = ] 'description': A description of the parameter.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

Database Mail uses the following parameters:

Parameter name	Description	Default Value
AccountRetryAttempts	The number of times that the external mail process attempts to send the e-mail message using each account in the specified profile.	1
AccountRetryDelay	The amount of time, in seconds, for the external mail process to wait between attempts to send a message.	5000
DatabaseMailExeMinimumLifeTime	The minimum amount of time, in seconds, that the external mail process remains active. When Database Mail is sending many messages, increase this value to keep Database Mail active and avoid the overhead of frequent starts and stops.	600
DefaultAttachmentEncoding	The default encoding for e-mail attachments.	MIME
MaxFileSize	The maximum size of an attachment, in bytes.	1000000
ProhibitedExtensions	A comma-separated list of extensions which cannot be sent as an attachment to an e-mail message.	exe,dll,vbs,js
LoggingLevel	Specify which messages are recorded in the Database Mail log. Possible values are 1, 2, or 3. 1 - This is normal mode. Logs only errors. 2 - This is extended mode. Logs errors, warnings, and informational messages. 3 - This is verbose mode. Logs errors, warnings, informational messages, success messages, and additional internal messages. Use this mode for troubleshooting.	2

The stored procedure sysmail_configure_sp is in the msdb database and is owned by the dbo schema. The procedure must be executed with a three-part name if the current database is not msdb.

Permissions

Execute permissions for this procedure default to members of the sysadmin fixed server role.

Examples

A. Setting Database Mail to retry each account 10 times

The following example shows setting Database Mail to retry each account ten times before considering the account to be unreachable.

EXECUTE msdb.dbo.sysmail_configure_sp
    'AccountRetryAttempts', '10' ;

B. Setting the maximum attachment size to two megabytes

The following example shows setting the maximum attachment size to 2 megabytes.

EXECUTE msdb.dbo.sysmail_configure_sp
    'MaxFileSize', '2097152' ;

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

sysmail_configure_sp (Transact-SQL)

Tasks

Reference

Concepts

Community Additions