Removing old items from gn_TaskLogTable

Build 1501 on 14/Nov/2017  This topic last edited on: 5/Aug/2014, at 16:35

The gn_TaskLogTable should be kept clean by the cleanup process itself which is deleting entries older than 24 hours (default).

If the table becomes very big for any reason, there may occur a timeout when the system tries to remove the entries.

In such case, delete manually all the entries older than one day using this query:

delete gn_TaskLogTable where DATEDIFF(day,gn_Time,GETDATE()) >= 1