May 2009 - Posts

20 May 2009
Monitoring SQL Agent Jobs
In my last post I showed how to reliably get your SQL Agent jobs to only bother you if they fail. But how can you be confident that they are in fact running? Well, what I did is I set up a report in Reporting Services that reads the job history tables on a list of servers and shows me what jobs have... Read More...
no comments
Filed under: ,
14 May 2009
Better Notification from SQL Agent Jobs
I manage about 10 SQL servers and I rely heavily on SQL Agent jobs to do this. My aim is to get everything going smoothly with minimal intervention from me, but I want to know straight away when something goes wrong. SQL Agent has an excellent scheduler and what you can do in a job step is flexible and... Read More...
no comments
Filed under: ,