Report Server 10.0.2531.0 Hello, We’ve been using SSRS for more than 1 year now. Number of the reports and subscriptions were gradually increasing. Recently I started to see the following errors in the SQL Server Agent Error Logs: 12/20/2010 09:32:07,,Error,[000] Refresh of schedule 98106 failed because the parent job (0xB26B51B567B16C45940C9AA7132F8A85) was not found in the job cache 12/20/2010 09:32:07,,Error,[000] Failed to retrieve job 0xB26B51B567B16C45940C9AA7132F8A85 from the server 12/20/2010 09:32:07,,Error,[298] SQLServer Error: 3621<c/> The statement has been terminated. [SQLSTATE 01000] 12/20/2010 09:32:07,,Error,[298] SQLServer Error: 2601<c/> Cannot insert duplicate key row in object 'dbo.sysjobactivity' with unique index 'clust'. [SQLSTATE 23000] 12/20/2010 09:32:07,,Warning,[156] Job 0xB26B51B567B16C45940C9AA7132F8A85 does not exist in the job cache: attempting to re-acquire it from the server... 12/20/2010 09:32:07,,Error,[000] Failed to retrieve job 0xB26B51B567B16C45940C9AA7132F8A85 from the server 12/20/2010 09:32:07,,Warning,[000] Job 0x630FB2CAF3AB084DA67CDEAF89F91E92 does not exist in the job cache 12/20/2010 09:32:01,,Error,[000] Refresh of schedule 98105 failed because the parent job (0x630FB2CAF3AB084DA67CDEAF89F91E92) was not found in the job cache 12/20/2010 09:32:01,,Error,[000] Failed to retrieve job 0x630FB2CAF3AB084DA67CDEAF89F91E92 from the server 12/20/2010 09:32:01,,Error,[298] SQLServer Error: 3621<c/> The statement has been terminated. [SQLSTATE 01000] 12/20/2010 09:32:01,,Error,[298] SQLServer Error: 2601<c/> Cannot insert duplicate key row in object 'dbo.sysjobactivity' with unique index 'clust'. [SQLSTATE 23000] 12/20/2010 09:32:01,,Warning,[156] Job 0x630FB2CAF3AB084DA67CDEAF89F91E92 does not exist in the job cache: attempting to re-acquire it from the server... 12/20/2010 09:32:01,,Error,[000] Failed to retrieve job 0x630FB2CAF3AB084DA67CDEAF89F91E92 from the server I’ve never seen them before, or they happen very rare, while currently they happen every 2 - 5 min. So far I cannot see that those errors have any impact, but their number and regularity is quite disturbing. Why it happens and what can be done about that? Also, by now there are hundreds of thousands jobs accumulated in SSRS SQL Server Agent Jobs folder (and corresponding msdb system tables of course), and it seems that vast majority of them is just outdated garbage which is just sitting there. Is there any way to safely cleanup those system tables? Thank you, Alex