How to set up SQLAgentMail (Enterprise Manager)

How to Install SQL Server 2000

How To

How to set up SQLAgentMail (Enterprise Manager)

To set up SQLAgentMail

  1. Expand a server group, and then expand a server.

  2. Expand Management, right-click SQL Server Agent, and then click Properties.

  3. If you have configured a mail profile using a domain account different from the one used by Microsoft® SQL Server™, click This account, and then enter the Microsoft Windows NT® 4.0 or Windows 2000® account name and password used to create the mail profile for SQLAgentMail.

  4. In the Mail profile box, select the mail profile you created for SQLAgentMail.

  5. Click Test to check the ability of the system to start and stop mail client services with the profile entered.

    You should receive a message that SQL Mail has started successfully and stopped a mail session with this profile.