Hi! I am hoping someone can explain how I can determine the jobID (report). If a report is misbehaving,we would like to determine the subscribed id associated with report. We can cancel the job to stop the report from running this time, we would like to be able to prevent it from running again. but I have not been able to determine a way programatically. I have listed subscribed reports by using subscriptions = rs.ListSubscriptions(item.Path) above code gives us list of subscribed reports and all properties of it,now i want to find jobID associated with this report. Any help would be greatly appreciated. Thanks in advance,mhassanshahbaz

Please check here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112427http://uk.linkedin.com/in/ramjaddu

Thank you for your reply. I have to do it in vb not in sql.mhassanshahbaz