Release : 12.1
Component : CA WORKLOAD AUTOMATION iDASH FOR CA 7
This is the query we run to do the deletions on Oracle DBs. This is set up to do batches of 10,000 runs at a time. This should deleted things older than "now minus 92 days" - which is the value inserted in both of the '?' positions in the SQL statement.
COUNTER INTEGER :=0;
COUNTER := COUNTER + 1;
DELETE from idash_hist_job_run_ca7 WHERE end_time < ? AND rownum <= 10000;
SELECT COUNT(*) INTO CANT from idash_hist_job_run_ca7 WHERE end_time < ?;
exit when CANT = 0;
If iDash is receiving a success response on this query, as far as it knows, everything earlier than now - 92 days should be deleted.