Setting Up SQLAgentMail

SQL Mail and SQLAgentMail can use the same mail profile or they can use different mail profiles. If necessary, each mail profile can be configured within their own domain accounts.

Configuring a SQL Mail Profile

When configured, mail profiles are specific to the Microsoft® Windows NT® user domain account that is activated when a user logs on to Windows NT successfully. SQL Mail must have a mail profile created in the same user domain account or context that is used to start SQL Server. When a mail stored procedure is executed, SQL Mail looks for the defined mail profile in the domain account that triggered it.

If you plan to use mail stored procedures you must:

• Have a mail server that is simple MAPI-compliant.
• Configure a mail profile for MSSQLServer to use to connect to your mail server.

To configure a mail profile

To set up SQL Mail

Configuring a SQLAgentMail Profile

If you plan to send notifications to operators by e-mail or pager, you must:

• Have a mail server that is simple or extended MAPI-compliant.
• Configure a mail profile for SQL Server Agent to use to connect to your mail server.
• Have a mail server that is able to communicate with your pagers.

A mail profile is required by SQLAgentMail to start a mail session and send notification by e-mail or pager. A SQL Server Agent mail session is started every time that the SQLServerAgent service is started. You can create the profile with a mail client, such as Microsoft® Outlook™, that is installed locally on the SQL Server computer.

To configure a mail profile

To set up SQLAgentMail

›

Sharing a Profile with SQL Mail

SQL Mail and SQLAgentMail sessions may be configured to use the same Windows NT domain user account. When using the same domain account, SQL Mail and SQLAgentMail can share the same mail profile using a common mailbox.

Microsoft® SQL Server™ uses two separate mail sessions:

• The MSSQLServer service uses a mail session that is referred to as SQL Mail.
• SQL Server uses this mail session when your database applications execute the xp_sendmail extended stored procedure to send a message or query result set to a recipient.
• The SQLAgentMail uses a mail session that is exclusive to SQL Server Agent activities.

Creating Separate Profiles

You can configure separate mailboxes for SQL Mail and SQLAgentMail by creating separate mail profiles. There are two ways to accomplish this:

1. Use separate domain accounts for each service. This requires you to configure a mail profile for each user account.
2. Use the same domain account for each service and create multiple mail profiles.

For more information about setting up and configuring mail clients and mail profiles, see your Windows NT documentation.