Browse by Tags
All Tags »
SQLAgent (
RSS)
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...
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...
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...
How to force a SQL Agent job to keep going after an error, yet still notify you that something went wrong....