Cleaning up the CommandLog table

The CommandLog table containing logs of operations performed must be cleaned up daily.

Use the following command to delete logs older than 30 days:

DELETE FROM master.dbo.CommandLog
WHERE StartTime < DATEADD(day, -30, GETDATE())