In my current project we have a requirement in which we need to send SSRS report through Email,deployed in sharepoint 2010. We have scheduled a SQLSERVER Agent job which refreshes data in our database, on top of which our report is created. Now we have another need in which we have to stop subsciption and email of report if our SQLSERVER Agent job fails. Could anyone suggest how can i configure subscription dynamically either through SSIS script task , c# assembly or if there is any other way..... ?? Thanks in advance ...

Two ways You can change the schedule of the subscription such that it does not run :- http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.setdatadrivensubscriptionproperties Or you can delete the subscription http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.deletesubscription The other thing you can do in an unsupported fashion is to disable the associated schedule (which is a sql agent job). Josh Ash

Two ways You can change the schedule of the subscription such that it does not run :- http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.setdatadrivensubscriptionproperties Or you can delete the subscription http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.deletesubscription The other thing you can do in an unsupported fashion is to disable the associated schedule (which is a sql agent job). Josh Ash