--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
Great Information. Thanks for sharing follow us:
ReplyDeletesql server DBA training in Hyderabad
Thanks for your valuable feedback and please subscribe my blog for more updates.
Delete