Category Archives: SQL Agent Jobs
-
All jobs that ran during a given time frame.
1May 6, 2021 by Kenneth Fisher
Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of …
Continue reading -
How do I let someone execute a SQL Agent job they don’t own?
12April 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 -
Command shell steps in SQL Agent jobs only process a single command.
1April 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 -
Default SQL Agent Reports – Top Jobs
3July 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 -
Certificates, Proxies and Jobs! Oh My!
3April 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 -
Reusing schedules in SQL Agent
1January 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 -
Finding the error from a failed job.
5October 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 -
Building a job to monitor other jobs
5May 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 -
Check your SQL Agent history settings before it’s too late!
8February 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 -
A pattern to do beginning of period calculations.
Leave a commentNovember 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
SQL Studies 