Microsoft® SQL Server 2012 Unleashed

Enabling SQL Agent Mail

Next, you need to enable SQL Server Agent to use Database Mail. You right-click the SQL Server Agent node and then select Properties. On the left side of the Properties dialog that appears (see Figure 12.2), you click the Alert System link. Under the Mail Session group, you check the Enable Mail Profile check box. In the Mail System drop-down list, you select Database Mail. In the Mail Profile drop-down list, you select the default SQL 2012 profile you created earlier and then click OK. By doing this, you are telling SQL Server Agent to use the SMTP servers in your default profile to send email. You need to restart SQL Server Agent by using the right-click menu. Additionally, you may need to enable SQL Server Agent’s extended ...