SQLAgentMail can use its own domain account and mail profile that is different from the one set up for SQL Mail. With Microsoft® SQL Server™ version 7.0, you can configure SQLAgentMail e-mail messages to be sent when:
Alerts can be configured to send e-mail notification of specific events that occur without implementing SQL Mail. For example, alerts can be configured to notify an operator of a particular database event that may need immediate action.
For more information about configuring Alerts, see Defining Alerts.
E-mail messages can be sent to a list of recipients informing them of the status of scheduled jobs for possible user action. You can expand the capabilities of jobs to include sending a result set by e-mail to a list of recipients. For example, a monthly inventory report could send SQLAgentMail notification to the designated operators and the result set to the purchasing manager and supplier.