Enable email notification for SQL Jobs
Note: Make sure email profile and account are setup on the SQL Server first. To enable SQL Server Agent job email notification go to … SQL Server Agent -> Properties -> Alert System -> Mail session -> Enable mail profile