Hi There
I need to get rid of all subscriptions (including cleaning up all associated sql jobs) for RS 2000 and 2005.
We have hundreds of reports , going through them 1 by 1 is not an option.
When i look at the system tables, i join Subscription to Catalog, but i find reports with subscriptions in the system tables but when i go to Report Manger there is no subscription for the report.
In a nutshell , how can i see all valid subscription for all reports in RS, how can i delete all of them and make sur eall sql jobs associated etc are deleted.
Thanx