Disable or Pause Report and Subscription Processing

There are several approaches you can use to disable or pause Reporting Services report and subscription processing. The approaches in this topic range from disabling a subscription to interrupting the data source connection. Not all approaches are possible with both Reporting Services server modes.The following tables summaries the methods and supported Reporting Services server modes:

In this topic

Supported server mode
Enable and disable subscriptions Native mode
Pause a shared schedule Native and SharePoint mode
Disable a shared data source Native and SharePoint mode
Modify role assignments to prevent access to a report (Native mode) Native mode
Remove manage subscription permissions from role (Native mode) Native mode
Disable delivery extensions Native and SharePoint mode

Enable and disable subscriptions

Tip

New in SQL Server 2016! Enable and disable subscriptions. New user interface options allow you to quickly disable and enable subscriptions. The disabled subscriptions maintain their other configuration properties such as schedule and can be easily enabled. You can also programmatically enable and disable subscriptions or audit which subscriptions are disabled.

reporting services subscription ribbon

In Native mode Report Manager, browse to the subscription from either the My Subscriptions page or the Manage page of an individual subscription. Select one or more subscriptions and then click either the disable disable a reporting services subscription button or enable button enable a reporting services subscription on the ribbon. Disabled subscriptions are flagged with a warning icon status warning of a reporting services subscriptio and the status is listed as Disabled.

Reporting Services writes a row in the Reporting Services log when a subscription is disabled and another entry when the subscription is enabled. For example, in report server log file:

C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles\ReportServerService__10_16_2014_00_02_18.log

you see rows similar to the following:

library!ReportServer_0-1!b08!10/16/2014-16:21:14:: i INFO: Call to DisableSubscriptionAction(SubscriptionID=e843bc2b-023e-45a3-ba23-22f9dc9a0934)

library!ReportServer_0-1!2eec!10/16/2014-16:44:18:: i INFO: Call to EnableSubscriptionAction(SubscriptionID=e843bc2b-023e-45a3-ba23-22f9dc9a0934).

PowerShell related content Use Windows PowerShell to disable a single subscription: Use the following PowerShell script to disable a specific subscription. Update the server name and subscription ID.

#disable specific subscription  
$rs2010 = New-WebServiceProxy -Uri "http://SERVERNAME/ReportServer/ReportService2010.asmx" -Namespace SSRS.ReportingService2010 -UseDefaultCredential;  
$subscriptionID = "subscription guid”;  
$rs2010.DisableSubscription($subscriptionID);  

You can use the following script to list all subscriptions with their IDs. Update the server name.

#list all subscriptions  
$rs2010 = New-WebServiceProxy -Uri "http://SERVERNAME /ReportServer/ReportService2010.asmx" -Namespace SSRS.ReportingService2010 -UseDefaultCredential;  
$subscriptions = $rs2010.ListSubscriptions("/");  
$subscriptions | select subscriptionid, report, status, path  

PowerShell related content Use Windows PowerShell to list all disabled subscriptions: Use the following PowerShell script to list all of the disabled subscriptions on the current Native mode report server. Update the server name.

#list all disabled subscriptions  
$rs2010 = New-WebServiceProxy -Uri "http://uetestb03/ReportServer/ReportService2010.asmx" -Namespace SSRS.ReportingService2010 -UseDefaultCredential;  
$subscriptions = $rs2010.ListSubscriptions("/");  
Write-Host "--- Disabled Subscriptions ---";  
Write-Host "----------------------------------- ";  
$subscriptions | Where-Object {$_.Active.DisabledByUserSpecified -and $_.Active.DisabledByUser } | select subscriptionid, report, status, lastexecuted,path | format-table -auto  

PowerShell related content Use Windows PowerShell to enable all disabled subscriptions: Use the following PowerShell script to enable all subscriptions that are currently disabled. Update the server name.

#enable all subscriptions  
$rs2010 = New-WebServiceProxy -Uri "http://SERVERNAME/ReportServer/ReportService2010.asmx" -Namespace SSRS.ReportingService2010 -UseDefaultCredential;  
$subscriptions = $rs2010.ListSubscriptions("/") | Where-Object {$_.status -eq "disabled" } ;  
ForEach ($subscription in $subscriptions)  
{  
    $rs2010.EnableSubscription($subscription.SubscriptionID);  
    $subscription | select subscriptionid, report, path  
}  

PowerShell related content Use Windows PowerShell to DISABLE all subscriptions: Use the following PowerShell script to list disable ALL subscriptions.

#DISABLE all subscriptions  
$rs2010 = New-WebServiceProxy -Uri "http://SERVERNAME/ReportServer/ReportService2010.asmx" -Namespace SSRS.ReportingService2010 -UseDefaultCredential;  
$subscriptions = $rs2010.ListSubscriptions("/") ;  
ForEach ($subscription in $subscriptions)  
{  
    $rs2010.DisableSubscription($subscription.SubscriptionID);  
    $subscription | select subscriptionid, report, path  
}  

Pause a shared schedule

If a report or subscription runs from a shared schedule, you can pause the schedule to prevent processing. All report and subscription processing driven by the schedule is deferred until the schedule is resumed.

  • SharePoint mode: SharePoint Settings In Site settings, select Manage shared schedules. Select the schedule and click Pause selected schedules.

  • Native mode: In report manager, click Site Settings. Select the schedule and then click Pause.

Disable a shared data source

One advantage to using shared data sources is that you can disable it to prevent a report or data-driven subscription from running. Disabling a shared data source disconnects the report from its external source. While it is disabled, the data source is unavailable to all reports and subscriptions that use it.

Note the report still loads even if the data source is unavailable. The report does not contain data, but users with appropriate permissions can access the property pages, security settings, report history, and subscription information associated with the report.

  • SharePoint mode: To disable a shared data source in a SharePoint mode report server, browse to the document library that contains the data source. Shared data source icon Click the data source and then clear the Enable this data source check box.

  • Native mode: To disable a shared data source in a Native mode report server, open the data source in Report Manager and clear the Enable this data source check box.

Modify role assignments to prevent access to a report (Native mode)

One way to make a report unavailable is to temporarily remove the role assignment that provides access to the report. This approach can be used on all reports regardless of how the data source connection is made. This approach targets only the report, without affecting the operation of other reports or items.

To remove the role assignment, open the Security Properties page of the report in Report Manager. If the report inherits security from a parent, you can click Edit Item Security to create a restrictive security policy that omits role assignments that provide widespread access (for example, you can remove a role assignment that provides access to Everyone, and keep the role assignment that provides access to a small group of users, such as Administrators).

Remove manage subscription permissions from role (Native mode)

To prevent users from creating subscriptions, clear the Manage individual subscriptions task from the role. When you remove this task, the Subscription pages are not available. In Report Manager, the My Subscriptions page appears to be empty (it cannot be deleted), even if it previously contained subscriptions. Removing subscription-related tasks prevents users from creating and modifying subscriptions, but does not delete existing subscriptions. Existing subscriptions continues to execute until you delete them. To remove the permission:

  1. Open SQL Server Management Studio and con

  2. Connect to the Reporting Services report server.

  3. Expand the Security node.

  4. Select the role and clear the Manage individual subscriptions task.

Disable delivery extensions

All delivery extensions installed on a report server are available to any user who has permission to create a subscription to a given report. The following delivery extensions are available and configured automatically:

See Also

Subscriptions and Delivery (Reporting Services)
Reporting Services Configuration Files
Configure Report Manager (Native Mode)
Reporting Services Report Server (Native Mode)
Report Manager (SSRS Native Mode)
Security Properties Page, Items (Report Manager)