Browse by Tags

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...

Posted to DavidWimbush (Weblog) by DavidWimbush on Wed, Nov 25 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...

Posted to DavidWimbush (Weblog) by DavidWimbush on Wed, May 20 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...

Posted to DavidWimbush (Weblog) by DavidWimbush on Thu, May 14 2009

Page 1 of 1 (3 items)

SQL Server Blogs