Rotating Header Image

Just Keep Googling, Just Keep Googling…. SQL Agent Job Scheduling (Past and Future)

So I needed a script where I could provide a start and end date that could go into the past and into the future to determine all the job schedule executions that should have or will happen between the given dates.

I found bupkis

My Google-Fu was weak and couldn’t find anything so I pinged the OOBER smart folks on Twitter as I couldn’t be the ONLY person who ever wanted to do this.

This one was a tricky one to find… so tricky in fact that I started writing my own version and had moderate success but was still SO BUGGY.

I started to work through some of my bugs and low and behold I found the holy grail!!

http://weblogs.sqlteam.com/peterl/archive/2008/10/10/Keep-track-of-all-your-jobs-schedules.aspx

Twitter: Peter Larsson

Moral of the story: Don’t stop Googling cause there is a 99.9% chance that you’re not the first person to want to solve a particular problem.

Mr. Peter Larsson I thank you! 🙂

Thanks!!

Enjoy!! (Follow me on Twitter: @ColinStasiuk)

Post to Twitter Post to Delicious Post to Digg Post to StumbleUpon

Leave a Reply

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.