As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail.

 Configuring SQL Mail for SQLSERVERAGENT Alerts

1. Create SQL Admin account in Active Directory
2. Add SQL Admin account to Domain Admins group
3. Login as SQL Admin account
4. Create Outlook Profile using "Corporate" configuration
5. Select "Internet Mail" if using POP3
6. Create a contact in the Address Book for SQL Server Agent
7. Close Outlook
8. Logout of SQL Admin account
9. Login as Administrator
10. Open "Services" MMC
11. Change the "login on as" to the "SQL Admin account" on the following services:
1.  MSSQLSERVER
2.  MSSQLServerADHelper
3.  SQLSERVERAGENT
12. Open SQL Enterprise Manager
13. Expand "Support Services"
14. Right-click SQL Mail and select Properties
15. Use the drop-down menu to select Profile name
16. Exit SQL Mail
17. Expand "Management"
18. Right-click SQL Server Agent and select Properties
19. Make sure that the "Service Startup Account" is the SQL Admin account
20. Use the drop-down menu to select the Mail profile
21. Test it to make sure it is properly configured