update second datatable value when the system time matches the row value of first datatable?

[jshah-3]

I have 2 datatable

first data table have 3 fields

start time ,Name and Stop Time

Second datatable have 2 datafields

Name and value(0/1)

now i require that when the system time (actual time) becomes equal to start time of first datatable the value becomes 1 for that name in the second datatable

and when the  system time (actual time) becomes equal to stop time of first datatable the value becomes 0 for that name in the second datatable

is it possible to achieve?

[supandey]

Hi Jugal it should be doable with a Timer thing which checks for actual time=start and you can subscribe to that event to execute service in the background to set the value = 1. And this same logic can be used for your 2nd question.

You can check for the Timer Thing Template for more detail