Friday, March 06, 2015

What are those randomly generated SQL Server Agent jobs with the funny character sequence?

They some times look like 266102E5-EF3A-4D3B-B2AA-4907MM1DF28C or maybe D087318E-0C24-4895-9ECF-9530AA4D11B3 and they randomly show up in your Sql Server Agent list or do they randomly show up? Well they are your Reporting Services subscription jobs. The nice thing is that you can dissect the details in the job and then use those details in a master job plan. We recently did this so that our Report subscriptions were no longer time based, but became process based. We were originally scheduling the subscription to run based on what time we guessed the cube would finish processing and as you already know, guessing what time any process completes is a bad option. Once we took the details out of the randomly named job and put them in to the master job plan, we were able to deliver our subscription a lot earlier and without any manual process of checking to make sure it had all of the day's details.

Friday, December 12, 2014

Starting Again!

I was recently talking with a co-worker and he was talking about creating a blog, and I had mentioned that I have had a blog since 2007. Which got me thinking that I have not done a blog post in at least a year. So, I decided to try and start the blog back up. Unfortunately, it looks like all of my old posts are gone.

Most of the content of this blog will be about Microsoft Business Intelligence tools, SQL Server and a few other technology items.

Let's hope I can keep this blog updated.