Tag 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 -
My fantasy SQL feature(s)? T-SQL Tuesday #118
3September 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 -
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 -
SQL Homework – July 2018 – Create a SQL Agent Job
1July 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 -
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 -
Running code on the startup of SQL Server
1February 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 -
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
SQL Studies 