Disable and Enable Subscriptions in Reporting Services

Data Quality is very important and you want to make sure the business users get the Correct data from the Cube or from the Datawarehouses. In some circumstances where the data loads may fail you may want to disable the subscriptions so that the business users dont get the wrong reports. I use the following script to disable the reporting services subscriptions

UPDATE J SET
	J.Enabled = 0
FROM sysjobs J
INNER JOIN syscategories C
ON J.category_id = C.category_id
WHERE C.[Name] = 'Report Server'

You can add the above script as a job step if the BI Load fails.

Leave a Reply