Tag Archives: SQL Agent Jobs

  1. Running code on the startup of SQL Server

    1

    February 1, 2016 by Kenneth Fisher

    Every now and again you need to run code when your instance starts up. For example you might want to …
    Continue reading

  2. Reusing schedules in SQL Agent

    1

    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.

    3

    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

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

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

    5

    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

    17

    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

    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 847 other followers