How do I delete RTM historical data for a specific job?

In some special cases you may need to delete the RTM historical data for a specific job. This cannot be performed using the RTM console. Follow manual steps to delete data.

About this task

Delete the historical data of a specific job by using the following steps:

Procedure

For the job which is actually not running, use this command:

mysql -u root cacti -e "delete from grid_jobs where jobid={jobid};"

For the finished job, use this command:
```
mysql -u root cacti -e "delete from grid_jobs_finished where jobid={jobid};"  
```
Alternatively, replace the table grid_jobs_finished with grid_jobs_finished_<newname> according to the actual table name on the site.