SSRS – Creating and Using Shared Schedules Part 4



In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how to create shared schedules. Then I showed you how to create a standard subscription using the shared schedule. In this final post of the series, I am going to show you two ways to determine what reports are using the shared schedule.

If you missed my previous posts or need a refresher on how to create them, you can read them by navigating to the links above. Since this blog is part 4 of a series, if you want to follow along, I encourage you to do so. J I will be continuing on where I left off.

Now we have at least one subscription using our shared schedule. So, imagine if you will, you have created many subscriptions and several shared schedules. Many, many moons have passed and you have been asked to change the daily schedule that sends out some reports to key business users from daily at 6 AM to daily at 8 PM. So, you briefly wonder how in the world are you going to figure out which reports are using the schedule? That way, if you have them being delivered via email, you can send them an alert stating that the delivery time of the report is going to change accordingly.

Don’t worry. Microsoft has helped us out with this. Sort of like a dependency tracker, they have provided us a way to see what reports are using the shared schedule. All you have to do is navigate to the Site Settings within report manager and then drill into the schedules tab as shown in figure 4.

Figure 4: Site Settings - Schedules tab

Shared Schedules - sqlbigeek Brian K McDonald

Now select the shared schedule name that you have to modify. In my case, I am selecting the Daily 6 AM schedule. Next, click on the Reports tab to view the reports that use the schedule as demonstrated in figure 5 below.

Figure 5: Scheduling – Reports Using Shared Schedule

Shared Schedule Reports - sqlbigeek Brian K McDonald

Alternatively, you could also see the reports by using SSMS and connecting to your report server instance as shown in figure 6.

Figure 6: Using SSMS

Shared Schedules Using SSMS - sqlbigeek Brian K McDonald

Awesome! Now you can find out who the subscriptions are being sent out to and send that email to alert them of the change.

Here are links to the other posts in this series in case you want to keep reading:

  • Part 1 - Introducing Shared Schedules
  • Part 2 - Creating Shared Schedules
  • Part 3 - Creating a Standard Subscription
  • Part 4 - Shared Schedule Management


I hope that you have enjoyed this series. If you did, please take just a moment to rate it below! Also, if you don’t already, please be sure to follow me on twitter at @briankmcdonald. Also note that you can subscribe to an RSS feed of my blogs or find me at any of the below methods.




sqlbigeek Brian K McDonald


Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant


Blogs: SQLBIGeek | SQLServerCentral | BIDN Articles | BIDN Blogs | SQLServerPedia

Twitter: @briankmcdonald