How to: Configure SQL Server Agent Mail to Use SQL Mail (SQL Server Management Studio)
This topic describes how to use SQL Server Management Studio to set up SQL Server Agent Mail to use SQL Mail. Before you can use SQL Mail, you must enable SQL Mail and set up a mail profile. SQL Mail can be enabled by opening the Properties dialog box from the SQL Mail node, by using the Surface Area Configuration facet of Policy-Based Management, or by the using the sp_configure stored procedure.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
If you are using Microsoft Outlook Express, clear the Warn me when other applications try to send mail as me check box on the Security tab of the Options dialog. If you do not clear this check box, SQL Server Agent cannot automatically send e-mail messages to operators by way of SQL Mail.
To set up SQL Mail to use SQL Mail
In Object Explorer, expand a server.
Right-click SQL Server Agent, and then click Properties.
On the Alert System page, click Enable mail profile. If this option is not available, enable SQL Mail and set up a mail profile.
In the Mail system list, choose SQL Mail.
In the Mail profile list, select the Extended MAPI mail profile you created for SQL Mail. For more information about configuring a mail profile, see How to: Configure Mail Profiles for Use by SQL Mail (Windows).
Restart the SQL Server Agent service for your changes to take effect. For more information, see How to: Restart the SQL Server Agent Service (SQL Server Management Studio).
To test SQL Mail, send a test message using xp_sendmail.