Thursday, April 30, 2015

Is there any possibility to block emails of subscriptions we are about to create in 2008 (folder level) and enable back the emails once we are done creating the subscriptions

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:

  1. 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
  2. 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