Garry Bargsley continues a series on alerting when SQL Agent jobs fail:
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.
Click through for the details, as well as a full code sample in Powershell.