Tag Archives: SQL Agent Jobs
-
Building a job to monitor other jobs
5May 4, 2015 by Kenneth Fisher
The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows …
Continue reading -
Check your SQL Agent history settings before it’s too late!
8February 10, 2014 by Kenneth Fisher
A little while back I was doing some research into a failed job and ran into a slight problem. The …
Continue reading -
A pattern to do beginning of period calculations.
Leave a commentNovember 20, 2013 by Kenneth Fisher
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning …
Continue reading -
A T-SQL query to get current job activity
30September 5, 2013 by Kenneth Fisher
I recently had the task of collecting job activity for the purposes of turning it into a report for some …
Continue reading -
Ordering steps in a SQL Agent job
2July 8, 2013 by Kenneth Fisher
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is …
Continue reading
SQL Studies 