Category Archives: SQL Agent Jobs

  1. Building a job to monitor other jobs

    5

    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

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

    3

    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

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

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

    14

    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

  5. Ordering steps in a SQL Agent job

    2

    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

Follow

Get every new post delivered to your Inbox.

Join 804 other followers