Re: Automate an update

This may be complex but I think can work
,
create a payload in advanced queue with delay=8hrs
( or whatever ). run a job(immediately..no future timing) which listens to
this advaced queue . As soon as job gets the event in queue (after 8hrs) it will
update the column based on logic ( if time = ...blah blah ) and at the end it
will insert another item in queue with delay=8hrs . So in 24hrs job
will get 3 payloads and check the timing at that time .. . This job
will be running in an infinite loop .
You can create some other procedure to stop it , by
sending some particuler item in queue .

As usual there might be more methods you will be
getting in few minutes :)