Tag Archives: SQL Agent Jobs
-
One job to rule them all
Leave a commentAugust 31, 2023 by Kenneth Fisher
Three batch jobs that run all night.Seven for the DBAs to maintain and protect.Nine quick little jobs run by the …
Continue reading -
SQL Agent job history on a Managed Instance
4July 25, 2023 by Kenneth Fisher
The defaults for saving SQL Agent Job history are ok (at best), so you should probably check and update them …
Continue reading -
All jobs that ran during a given time frame.
2May 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