Category Archives: SQL Agent Jobs

  1. Certificates, Proxies and Jobs! Oh My!


    April 27, 2016 by Kenneth Fisher

    Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need …
    Continue reading

  2. Reusing schedules in SQL Agent


    January 25, 2016 by Kenneth Fisher

    I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor …
    Continue reading

  3. Finding the error from a failed job.


    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 you …
    Continue reading

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

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

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

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

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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,580 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013