Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS How to trigger subscription when data is ready


SSRS How to trigger subscription when data is ready

Author
Message
christian_t
christian_t
SSC-Enthusiastic
SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)

Group: General Forum Members
Points: 120 Visits: 525
hi guys,

I have a few Reports that are subscripte bei a normal subscription meaning having a fixed time where it will be executed.
However it happens, that the data for those reports is not ready yet.

I thought this problem will be solved by a data driven subscription but there you just can get the "parameters" (e.g. TO, CC, Subject, Report-Parameters) set. There seems no way to say, that there should be an check up on if the data is ready (e.g. select table for success) and then delay 5 minutes to check again.

How did you fix this issue?

Mitch
Daniel Bowlin
Daniel Bowlin
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2950 Visits: 2629
You could take a couple approaches.

You could disable the agent job that runs the subscription. Then put some code at the end of your data load that executes the agent job using sp_start_job.

Or, you could build some sort of log table that your data load writes to when it is complete, then use the data driven subscription to test for certain conditions in the log before executing the report.
tnk
tnk
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 443
2008 R2 has an option to execute the data-drive subscription, "When the report data is updated on the report server".
christian_t
christian_t
SSC-Enthusiastic
SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)

Group: General Forum Members
Points: 120 Visits: 525
Thx guys.
As I am looking for a more native way to handle this, so non so technical people can configure those Subscription I will wait for the R2, which I will get in the next few weeks and will look in to the new data-driven execution.
tech.groupchat
tech.groupchat
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 9
Did you get any answer how to execute/trigger report when data is ready? I am looking for same thing. I am using R2 but do not know exact steps how to achive this.
tech.groupchat
tech.groupchat
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 9
I used data driven subscription where report executes and distirbutes single/multple times and delivered to by email.

Could you please tell me steps where I can set something where subscription will check if data is ready every 5 mins and if yes then execute report for once and stop running second time. We have early morning data load where I like to trigger report execution as soon as data ready.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search