Schedule Job : "Calculate SLA Results", taking very long time to execute.

[SukanyaP]

While performing system health checks, we observed that the scheduled job "Calculate SLA Results" is taking a long time to execute.

When we checked the transactions, we noticed that the server response time and transaction load were high while executing the job to pull the data. This discrepancy occurs because the scheduled job is executed on a daily basis, which affects node transactions and causes a decline in system performance.

Please suggest any possible ways to reduce the job execution time to avoid unnecessary transactions and reduce the server load.

Manys thanks in Adavance,

Sukanya.P

[JC Moller]

I have the same issue on our on-prem instance. The job runs for almost 30 minutes and has become slower as time passes by. Just need to know what this job does exactly and then determine if we will keep it running.