Event deletion job does not work
We have set the job on event and event archive table following the below:
INSERT INTO Configuration VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 1)
INSERT INTO Configuration VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 1)
We have set this job for all the client orgs in our database. But I see this job is not working and is not cleaning up the old records in the event table.
When I see the task schedule for the status of the event archive job, it says status failed:
FAILURE;com.microsoft.sqlserver.jdbc.SQLServerException: socket closed;0;NULL;NULL;NULL
Can you please provide some solution how to configure to make this job working.