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.
