We've noticed that some of our SSRS servers have over 1,000 SQL Agent jobs that haven't run in a year or more. These seem to be associated with Schedules that have a RecurrenceType of 1. Is there any sort of SSRS functionality to clean these up by removing the Schedules, ReportSchedules and SQL Agent jobs?Chuck Hottle

Hi, From your description, I noticed you need to remove subscriptions which only need to be executed for one time. If so, I would suggest you refer to the similar thread at http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/bdd98586-66d2-4e7f-b6c3-ab2688e0b525 Hope this helps. Thanks, Tony ChainTony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.