Posted by: Colin Smith
Jobs, Powershell, Reporting
I told you about the SQL server jobs repository I was buyilding, and that is done. It works great and I have one report written that gives me an overview of all the jobs in my environment and what succeeded and what failed in the past 24 hours. That is very nice but because of that, I noticed a few jobs that have been failing for a long time and that are somewhat important to us as a DBA team. So I am going to change the way that we do things and I am going to use Powershell to do it. I will be sharing the information with you as I go and I think you will like what I am building here.