Welcome to Part 2 in the series about SQL Server Agent Job Failures. In this part you are going to learn how to build an HTML report with Failed Agent Job information and send the report via e-mail to the interested team(s). Let’s get started putting the pieces together to build our report. First step: Picking up where we left off based on Part 1 of the series, the $servers variable is populated with all the SQL Servers you will be checking for Failed Agent Jobs.
