• Please refer http://msdn2.microsoft.com/en-us/library/ms186358(d=ide).aspx.

    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, choose Database Mail.

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