Microsoft® SQL Server 2008 R2 Unleashed

Using SQL Server Agent Mail

As with SQL Server 2000, SQL Server 2008’s Agent has the capability to send email notifications. They may be triggered by alerts or scheduled task completions, such as jobs. SQL Server 2008 provides the option of using either SQL Mail or Database Mail to do the sending, but SQL Mail will soon be phased out, and Database Mail is by far the more robust choice. As with Database Mail, SQL Server Agent Mail is turned off by default, and you must configure it via SMSS or T-SQL, as described in the following sections.