Hi Prabhat Y,
Per my understanding that you are doing the migration from SSRS 2005 to SSRS 2008 and now you are re-creating the 3500 subscriptions in the SSRS 2008, so you want to the new created subscription in SSRS 2008 will be pause and not execute at this time, right?
Generally, we have several method to pause the subscription processing, please reference to details information below:
- When you created an subscription, an new Sql Server Agent job will be created too, so you can you can just uncheck the 'enabled' checkbox in the job properties as below to disable the execution of the job,you can also stop the SQL Server Agent Services manually, all your subscriptions will stop running:
More information, Please reference to:
How to temporarily stop SSRS subscriptions - You can also disable a Shared Data Source, pause a Shared Schedule to pause the subscription processing.
Pause Report and Subscription Processing
If you still have any problem, please feel free to ask.
Regards,
Vicky Liu
Vicky Liu
TechNet Community Support
No comments:
Post a Comment