Tag Archives: SQL Agent Jobs

  1. My fantasy SQL feature(s)? T-SQL Tuesday #118

    1

    September 10, 2019 by Kenneth Fisher

    It’s fantasy football time again? Oh, fantasy feature? Oh, yea, that makes a lot more sense for #tsql2sday. What’s #tsql2sday? …
    Continue reading

  2. How do I let someone execute a SQL Agent job they don’t own?

    2

    April 15, 2019 by Kenneth Fisher

    In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that …
    Continue reading

  3. SQL Homework – July 2018 – Create a SQL Agent Job

    Leave a comment

    July 2, 2018 by Kenneth Fisher

    For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used …
    Continue reading

  4. Command shell steps in SQL Agent jobs only process a single command.

    1

    April 23, 2018 by Kenneth Fisher

    I was working on a SQL Agent job recently that required a series of command shell commands. And it would …
    Continue reading

  5. Default SQL Agent Reports – Top Jobs

    1

    July 24, 2017 by Kenneth Fisher

    Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several …
    Continue reading

  6. Certificates, Proxies and Jobs! Oh My!

    3

    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

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

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

  9. Finding the error from a failed job.

    4

    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

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

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

Join 2,530 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013