Create Absence database schedule task error

Hi All,

I am currently facing an issue due to 'Create Absence for Next Day' database schedule tasks. This task is scheduled to execute every day during midnight (12:05 AM).

The problem description is given below:

1. Employee was on Sick leave (e.g. from 26-Jun-2023). Manager has created his/ her sickness absence from 26-Jun-23 with ‘Ongoing’ option.
2. Employee return back to work on 30-Jun-2023 and inform to Manager. On 5th Jul, Manager has stopped his/her sickness absence end date as 30-Jun-2023. Sickness absence will be stopped.
3. During the midnight of 6th Jul (12:05 AM), scheduled background job has exeucted and it has created additional sickness absence for previous day i.e. 5th Jul-2023. 

This issue is being replicated for multiple records when manager stop the sickness absence for past date.

Anyone can help if I am missing something or any solution available to resolve this issue.

Thanks