How to check record in not created in 24 hour in weekend and 16 hour in weekdays

lucky24
Tera Contributor

‎08-10-2023 04:57 AM

HI Team.

I have one table for ex-problem if there is no record created in 16 hour between monday to friday or no record created in 24 hour in saturday or sunday then I have to create incident 

.

for example last record created in on Tuesday and after that no record created til 16 hour then I have to created incident record and If last record created on saturday and after that no record created till 24 hour then I have to create incident,

How can we achieve this. please help me here?

Thanks

 

   

0 Helpfuls
  • 204 Views
1 REPLY 1

Community Alums
Not applicable

‎08-10-2023 05:29 AM

Hi Lucky,

You can create a schedule job that should run daily and keep track of the total number of the records in your ex-problem table and if record changes means new record is created then their should be condition that should check the difference between current and time and date of record created in your ex-problem table if it's according to your requirements then create a incident.

And for to store total number fo records you can create a property and store the number there. 

0 Helpfuls