SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Takes Query Plan Analysis and Performance Monitoring to a New Level

Reporting Service Subscriptions & The DBA

Subscriptions are a great feature of Reporting Services, easy to build, easy to manage. Ever look at them from the DBA perspective? Lots of jobs with names like "2C16F370-785E-4460-9821-066EE952B372"! Beyond the hard to manage-ness of the names though the jobs do surprisingly little work. We'll explore that, and talk about what happens if you rename of these jobs to something more meaningful.

Duration:
4 mins 46 secs
Skill Level:
100
Rating:
4.39 out of 5
Publish Date:
May 24, 2010
Reporting Service Subscriptions & The DBA You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Andy Warren
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

References



Comments
Charlie Bruno on 5/26/2010
Another excellent and highly informative video. Thanks.

Rudy on 5/26/2010
great video

Varun on 5/26/2010
good

Matt on 5/26/2010
Nice video, I have always wondered about why it creates those god awful names.

Kasey Wheeler on 5/26/2010
Good vid

Geoffrey Doebler on 5/26/2010
Great video, can you post the script you wrote to the the name and the path?

Geoffrey Doebler on 5/26/2010
never mind, I opened my eyes and found it under references.

darwin stahlback on 5/26/2010
Good coverage. i always curious what would happen if you renamed the jobs, but with so many other tasks at hand I felt it didnt require the indepth investigation. Id be curious if you do sucessfully figure out how to rename the jobs though.

C G on 5/26/2010
Like seeing where we can shoot ourselves in the foot.

E72B0A9423 on 5/26/2010
Helpful information.

Ralph Schwehr on 5/26/2010
usefull information as most dba's are running into these 'funky' subscription job names. Looking forward to see if these names can be changed :)

Rubens on 5/26/2010
Excellent info, thank-you.

Stephanie Brown on 5/26/2010
Certainly something we've all wondered about. Looking forward to what your further research shows regarding dependencies.

Anil Inampudi on 5/26/2010
gud one

Rich on 5/26/2010
Too bad MS didn't make these jobs stored in a separate domain, something akin to a different database schema. Thanks for helping make sense of these jobs. We're just rolling out SSRS, and I can imagine users creating a ton of subscriptions in the future!

Peter Schott on 5/26/2010
Same as the others - GUIDs for job names are extrememly painful and make trying to set up Data-Driven subscriptions a painful experience.

7F718A6344 on 5/26/2010
Wonderful - loved showing the result of renaming the job.

Christian Bahnsen on 5/26/2010
Keep up the great work!

Marco Francisco on 5/26/2010
Very cool demo. I've a demo with subscriptions and the way it works behind the scenes (DataBase), but in this perspective, this was very helpful.

Marco Francisco on 5/26/2010
Very cool demo. I've a demo with subscriptions and the way it works behind the scenes (DataBase), but in this perspective, this was very helpful.

Kenneth Wymore on 5/27/2010
I am looking forward to the next installment! I would love to see a way to modify the job names without messing up anything. What would be even better is to find a way to create the jobs with clean names when the subscription is created initially so you don't have to go back in and modify the job names later.

Kevin on 5/27/2010
Fascinating. Thanks for researching this.

Steve Culshaw on 5/29/2010
Excellent content, fingers crossed can find a way to consistently rename the Job

abdul samath on 5/30/2010
very useful

Ed Vassie on 6/1/2010
No sound heard

Javid Khan on 6/1/2010
Very helpful. I created many subs but unable to find the issue when changed the name.

Sankar Reddy on 6/6/2010
Andy, I know you in the community and the amount of work you put in to build these communities over the years. We haven't met before and I have tremendous respect for you. But the advice to change the job names here may not be a good one. Think of Reporting Services database as a system database and one shouldn't modify any part of it except using the supported api. If something breaks, I am sure it will then you MSFT will not support your case and one has to start over or go back to an older backup and loose work. The above is confirmed by the MSFT Reporting Services dev team also. Also during version upgrades, RS database schema will change and expect the schema and data types to be changed in the next few iterations. I am saying this because RS database uses NTEXT extensively but the data type might be going away soon hopefully! This is my opinion but you might disagree on this but throwing a word of caution here. Later, Sankar Reddy

Jeremy Espineda on 8/2/2011
great video!

David Branscome on 4/17/2012
Good!!

David Branscome on 4/19/2012
Good overview of some of the report scheduling processes



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions