SLA

[Nafisa Zaman]

How to automate SLA clock in such a way that it gets automatically resume & pause on the basis of store’s trading hours which could be extracted from Store Opening Times field from SNOW.

[Saurav11 · Accepted solution]

Hello,

If  different restaurants have different times then you can create different schedules and SLA's based on the restaurants should not be an issue.

Please mark my answer as correct based on impact.

[Saurav11 · Accepted solution]

Please mark my answer as correct based on impact.

[Saurav11 · Accepted solution]

Does all 13000 have different time. There will be common times i believe for multiple stores. So you should first group it and see how many have same time and how many different timings emerge and based on that we can go ahead.

[Nafisa Zaman]

Hi Saurav,

actual timings are not saved on location table, they stored it on apex table, and those values are saved as string format, so we can not compare string with time format.

[Nafisa Zaman]

yes,
How to group

[KimberlyConnel]

Thank you for the links sir, I found them useful for me. I appreciate you for helping me out.

[EveWaelchi]

Ensure that your script for calculating trading hours and adjusting the SLA clock is correctly implemented and thoroughly tested to avoid any disruptions in service.