all groups > sql server reporting services > december 2004 >
You're in the

sql server reporting services

group:

How to purge old schedules



How to purge old schedules billd
12/28/2004 6:49:02 PM
sql server reporting services: I am allowing users to create One-time Schedule's (via the Web Service API)
with "Stop this schedule on" automatically being set to the next day.

However, the Subscriptions list is never cleared for the report, even though
the schedules are weeks past the stop date. This results in dozens of
obsolete schedules being listed.

Is there any way to automatically purge old schedules from reporting
services, or do I need to do it within my own code?

Thanks,
Bill

Re: How to purge old schedules Daniel Reib [MSFT]
12/29/2004 10:25:20 AM
You will need to write your own code. There is no built in mechanism to
delete a subscription (or schedule) if it will not run again.

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Re: How to purge old schedules Jeff S.
2/22/2005 10:15:07 AM
I am currently trying to write a windows service that will delete all
inactive subscriptions on a given report. Is there a way to get a list of
subscriptions that are not filtered by owner? By filtered I mean I don't
want to have call ListSubscripions(report1, user1).

I would like to get all subscriptions for report1 at one time.



[quoted text, click to view]
AddThis Social Bookmark Button