Dela via

  • Artikel

How to: Configure SQL Server Agent Mail to Use Database Mail (SQL Server Management Studio)

This topic describes how to use SQL Server Management Studio to set up SQL Server Agent Mail to use Database Mail. Before you start this task, enable and configure Database Mail using the Database Mail Configuration Wizard.

To set up SQL Server Agent Mail to use Database Mail

  1. In Object Explorer, expand a server.

  2. Right-click SQL Server Agent, and then click Properties.

  3. Click Alert System.

  4. Select Enable Mail Profile.

  5. In the Mail system list, select Database Mail.

  6. In the Mail profile list, select a mail profile for Database Mail.

  7. Restart SQL Server Agent.