Page 2 of 2
Posted: Thu Dec 16, 2004 1:09 pm
by mak
That helps.
Thanks Craig
Posted: Thu Dec 16, 2004 2:48 pm
by ray.wurlod
There are two sets of things you need to remove.
In job logs, field number 7 is used to store the invocation ID. However, field number 7 is not exposed in the file dictionary of RT_LOG, so you need to generate a reference to it on the command line.
Code: Select all
DELETE FROM RT_LOGnnn WHERE EVAL "@RECORD<7>" = 'invocationID' AND TIMESTAMP < (CURRENT_DATE - 5);
You also need to remove the invocation entries from RT_STATUSnnn. Key values in RT_STATUSnnn consist of the job name, a ".", the invocationID or "" then, possibly, another "." and more information. I've found that two DELETE statements are safer.
Code: Select all
DELETE FROM RT_STATUSnnn WHERE @ID LIKE '%.invocationID.%';
DELETE FROM RT_STATUSnnn WHERE @ID LIKE '%.invocationID';
Obviously, substitute your own invocation ID and nnn values.