Forum Discussion
Resolver IIIHow to Stop Reports in Report Server from Running
Hello,
Is there a way I can stop my reports in report server from running without disabling the subscription one by one?
I have 35 reports uploaded but on public holidays they are not expected to run. I individually disable them which is a pain and enable them after holiday's. The number of reports may grow over time. I will appreciate a solution
No there is no global "pause all" option or anything like that. You could write a powershell script to loop through all the subscriptions (or a specific list of them) and disable them all that way using these cmdlets microsoft/ReportingServicesTools: Reporting Services Powershell Tools (github.com)
You can change the default timeout in the site settings ( from the gear icon in the top right corner of the portal)
And you can override this in the report properties for an individual report. Just click on the ... menu for the report and click on the Manage option.
3 Replies
- d_gosbell
Super User
No there is no global "pause all" option or anything like that. You could write a powershell script to loop through all the subscriptions (or a specific list of them) and disable them all that way using these cmdlets microsoft/ReportingServicesTools: Reporting Services Powershell Tools (github.com)
M_nwadibiaOne more Question. How can I adjust the RDL time-out so that if it runs for just 1hr and it does not export to user the report should stop execution. I have been searching for Video's on how to modify time out without success
- d_gosbell
You can change the default timeout in the site settings ( from the gear icon in the top right corner of the portal)
And you can override this in the report properties for an individual report. Just click on the ... menu for the report and click on the Manage option.