Browse by Tags

All Tags » SQL Server 2005 » SQLAgent (RSS)
25 November 2009
How to process a cube in a SQL Agent job
It can be done but it's not well documented and it's complicated by the fact that you can't easily get the result of the process. Unless you actively check and manually raise an error if there's been a problem, the job will report sucess no matter how screwed up the cube processing is... Read More...
5 comment(s)
Filed under: , ,
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: ,