Old Non-Existent Jobs Showing on "Jobs" Screen in the R&M Server

  • 7019414
  • 26-Feb-2015
  • 07-Aug-2017

Environment


Retain 3.x
Reporting & Monitoring Server

Situation


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?

Resolution


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]';

Additional Information

This article was originally published in the GWAVA knowledgebase as article ID 2483.