We havent opened our report server on our TEST box since December. Now all of the daily scheduled reports want to run. I've been dropping them individually, but how do I kill all "aged" scheduled reports en masse?
Ah- deactivating them all, shutting down the report server, reopening worked like a charm!
Hi Randall
We call a little proc to get rid of any existing report schedules as part of the test refresh, so we don't have to remember.
- I've posted it on my account if you want to have a look.
Ken Mcswain
Thanks! That's much more handy that the other way! Thanks for posting.
Randy