October 3, 2014 at 1:16 pm
We are trying to create a subscription for a report that takes a while to run. Problem that we are running into is once all of the parameters are filled we have to wait a long time to save the report as a job is started in Reporting Services that runs the report. Is there a way to prevent this from happening?
October 3, 2014 at 1:23 pm
Subscriptions are created as jobs within SQL Server Agent of the database instance that SSRS is using. That job simply tells the SSRS engine that a subscription needs to be run.
You might disable the job that gets created from within SQL Agent.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 3, 2014 at 1:42 pm
We don't even get that far in creating the subscription. AS soon as all of the parameters are filled in, the webpage to create the page sits and waits for a post back from the server. Looking into the SSRS I am seeing this job started, not the SQL Server Agent Job, and running along with looking into Activity Monitor showing that the Stored Procedure for this Report is being executed.
Also there is one parameter that has a default value based off one of the other datasets in this report so I wondering if that may be culprit and wonder if I that could be the culprit and if possible be able to be done another way?
Brian
October 6, 2014 at 2:12 am
piebri (10/3/2014)
We don't even get that far in creating the subscription. AS soon as all of the parameters are filled in, the webpage to create the page sits and waits for a post back from the server. Looking into the SSRS I am seeing this job started, not the SQL Server Agent Job, and running along with looking into Activity Monitor showing that the Stored Procedure for this Report is being executed.Also there is one parameter that has a default value based off one of the other datasets in this report so I wondering if that may be culprit and wonder if I that could be the culprit and if possible be able to be done another way?
Brian
What type of subscription are you trying to create?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 6, 2014 at 7:59 am
It is a timed Subscription.
Brian
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply