Reporting & Monitoring Server
I have old jobs displaying in the "Jobs" screen in the Reporting & Monitoring Server. Those jobs are old and had been even deleted from the Jobs dialog in the Server admin console. Even though my job expiration is set to 14 days, they are not going away. If I click on any one of those jobs, no job history is displayed; in fact, nothing happens.
How can I remove these jobs from the Reporting & Monitoring Server?
This can be done through a SQL delete query in the Retain database; however, the customer assumes all responsibility for doing this. You should have a backup of your database since the last archive job ran.
Run this query: delete jc from s_JobsCache jc where jc.JobName='[the job name]';
This article was originally published in the GWAVA knowledgebase as article ID 2483.