Browse by Tags

All Tags » SQLAgent (RSS)
25 November 2009 11:09

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...
Posted by DavidWimbush | 5 comment(s)
Filed under: , ,
24 June 2009 08:58

Start a SQL Agent Job in SQL

How do you start a SQL Agent job in SQL? I recently found myself wanting to be able to do this and it turns out it's really easy: exec msdb.dbo.sp_start_job 'Check Integrity' It returns as soon as the job has started, without waiting until...
Posted by DavidWimbush | with no comments
Filed under:
20 May 2009 22:41

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...
Posted by DavidWimbush | with no comments
Filed under: ,
14 May 2009 10:03

Better Notification from SQL Agent Jobs

How to force a SQL Agent job to keep going after an error, yet still notify you that something went wrong....
Posted by DavidWimbush | with no comments
Filed under: ,