Temporary enable and disable SSRS subscriptions

--Code Snippet

--To Check Subscription Status.

USE ReportServer

GO

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

GO