question

James Maddox avatar image
James Maddox asked

Is there a way to set up a shared subscription in SSRS?

At my new job we have an issue with SSRS we are trying to resolve. Our reports have a subscription that makes them run 7am on a daily basis, but sometimes the data that comes into the reports is invalid because a SSIS job failed, so the reports have to be run again in 15 minutes. The issue is we have to go into each report and tell each subscription to run again at 7:15. The question I have is, is their a way to have all the reports share one subscription so we dont have to change each individual subscription

ssrssubscriptions
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered

I'm a bit sketchy on this but I think there is a job in SQL Agent that runs each SSRS schedule. You should be able to tie the success of the SSIS job to trigger the SSRS job and get them in sync that way. If thats the case, cancel the SSRS schedule and only run it from the success of the SSIS job and you wont have to worry again.

If I get a chance to test this I'll update...


[Edit]
Well, Google wins: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/1d8799c6-abe6-4e15-8b20-cfb7d8094abc its been done, just like I described

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.