How to brute force delete subscriptions ?

Hello,

I restored a huge ReportServer backup on a dev machine and I do not want the subscriptions and their jobs.
I already changed the SMTP server address so emails will go to nowhere.

Now What is the best sequence to get a rid of all subscriptions?

Delete records (or truncate) from the ReportServer.Subscriptions table then delete all the subscriptions jobs or the other way around?

BTY, a centralized management of subscriptions as well as stuffing all these jobs into a folder would be a welcome addition.

Thanks,

Philippe

Safest way would be using a simple script for deleting all subscriptions via DeleteSubscription() SOAP API and rs.exe.|||

Igor Taranov -- MSFT wrote:

Safest way would be using a simple script for deleting all subscriptions via DeleteSubscription() SOAP API and rs.exe.

Thank you.

It is going to take me a little time to figure out how to do this.

BOL is not very user friendly about rs.exe.

Philippe