SSRS - Temporary Disable All Subscriptions

Temporary Disable Subscriptions

The InActiveFlags field in dbo.Subscriptions can be 1 or 0 (true or false).

--Code Snippet

--To Check Subscription Status.

USE ReportServer

SELECT dbo.Subscriptions.Description,

       dbo.[Catalog].Name,

       dbo.Users.UserName,

       InactiveFlags

FROM dbo.Subscriptions 

     INNER JOIN dbo.[Catalog] 

     ON dbo.Subscriptions.Report_OID = dbo.[Catalog].ItemID 

     INNER JOIN dbo.Users 

     ON dbo.Subscriptions.OwnerID = dbo.Users.UserID

------------------------------------------------------------------------------------------

--Temporary disables subscriptions while data warehouse is unavailable

UPDATE dbo.Subscriptions

SET InactiveFlags = 1

GO

--After this you can find, all the subscription where disabled until you again enable it.

Again enable subscriptions.

UPDATE dbo.Subscriptions

SET InactiveFlags = 0