Page History

First use the <basequery> for the database of your choice to find all the taskrunIds

--Oracle
--SELECT taskRunId FROM TaskRuns WHERE creationTime < SYSTIMESTAMP AT TIME ZONE 'GMT' -  NUMTODSINTERVAL(100, 'day')

--Postgres
--SELECT taskRunId FROM TaskRuns WHERE creationTime < CURRENT_TIMESTAMP AT TIME ZONE 'GMT' - interval '100 day'

--SQLServer
SELECT taskRunId FROM TaskRuns WHERE creationTime < GETUTCDATE()-100

-- DELETE FROM CurrentModuleInstanceRuns WHERE taskRunId IN (<baseQuery>) -- removed in 2017.02

--when happy with the TaskRuns to be removed do a cascade delete:
DELETE FROM ArchiveMetaData WHERE taskRunId IN (<baseQuery>)
DELETE FROM Reports WHERE taskRunId IN (<baseQuery>)
DELETE FROM ModuleInstanceRuns WHERE taskRunId IN (<baseQuery>)
DELETE FROM ModuleRunTables WHERE taskRunId IN (<baseQuery>)
DELETE FROM TaskRunCompletions WHERE taskRunId IN (<baseQuery>)
DELETE FROM TimeSeries WHERE creatorTaskRunId IN (<baseQuery>)
DELETE FROM ArchiveMetaData WHERE taskRunId IN (<baseQuery>)
DELETE FROM TaskRuns WHERE taskId IN (<baseQuery>)