SafeGuard Enterprise Task Scheduler: Events are not being deleted - Last Run Result shows 'Success'.
This issue only relates to a migrated environment and is planned to be fixed in a future version.
Due to a missing Stored Procedure in the MigrateSGN550_SGN560.sql script the EventLogDeletion.vbs script will not delete or move the event entries.
Known to apply to the following Sophos product(s) and version(s)
SafeGuard Management Center 5.60.0
All supported Operating Systems
What To Do
- Check if the Stored Procedure called dbo.spCleanEventTable is in the SafeGuard Database:
IMPORTANT: Before performing changes to the SafeGuard Database always create a full database backup!
- If dbo.spCleanEventTable cannot be found, use the SQL script in this downloadable zip file: 113697_create_procedure_spCleanEventTable.zip to create the Stored Procedure in the SafeGuard Database.
- In addition, the service account needs appropriate rights to the SafeGuard Enterprise Database. The service account must have execute rights on the dbo.spCleanEventTable stored procedure.