Views:

Customers can manually clear the PMDB.Job and PMDB.Log tables by truncating them. The following SQL Statements can be used to truncate the tables. Optionally you can back up the two tables as a history.

Select * from PMDB.Job

Select * from PMDB.Log

 

Select * into Bakup_<date>_PMDB_Job from PMDB.Job

Select * into Bakup_<date>_PMDB_Log from PMDB.Log

 

Select * from Bakup_112216_PMDB_Job

Select * from Bakup_112216_PMDB_Log

 

Truncate table PMDB.Log

Truncate table PMDB.Job

 

Alternately, you may wish to groom all records/entries before a specific time/date:

Select * from PMDB.Job

Select * from PMDB.Log

 

Select * into Bakup_112216_PMDB_Job from PMDB.Job where StartTime <= '2016-11-23'

Select * into Bakup_112216_PMDB_Log from PMDB.Log where StartTime <= '2016-11-23'

 

Select * from Bakup_112216_PMDB_Job

Select * from Bakup_112216_PMDB_Log

 

Delete from PMDB.Log where StartTime <= '2016-11-23'

Delete from PMDB.Job where StartTime <= '2016-11-23'