Category Archives: SQL Agent Jobs

  1. Finding the error from a failed job.

    Leave a comment

    October 7, 2015 by Kenneth Fisher

    This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say …
    Continue reading

  2. Building a job to monitor other jobs


    May 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

  3. Check your SQL Agent history settings before it’s too late!


    February 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

  4. A pattern to do beginning of period calculations.

    Leave a comment

    November 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

  5. A T-SQL query to get current job activity


    September 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

  6. Ordering steps in a SQL Agent job


    July 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


Get every new post delivered to your Inbox.

Join 809 other followers