How To
How to set up SQLAgentMail (Enterprise Manager)
To set up SQLAgentMail
- Expand a server group, and then expand a server.
- Expand Management, right-click SQL Server Agent, and then click Properties.
- 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.
- In the Mail profile box, select the mail profile you created for SQLAgentMail.
- 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.