Change column value status to be interrupted if no new record return after 10 mins I have three tables ,scadainfo_online, scadainfo_limit and scadainfo_status, data populated just like their name, self-described. 



My purpose is changing automatically "status" column's values in scadainfo_status if no new record get in scadainfo_online values in 10 minutes. there is a one-to-one relationship using column item_id.

So, how can I do it? Google told me about a job with about 30 seconds interval, is there another answer? Thanks.
Depending on your response to my comment above this may be what you want. Or it may at least show you the principle of what you want.

UPDATE scadainfo_status ss
SET ss.alarm_status = 'NO UPDATE'
WHERE ss.item_id IN (WITH updates
                       AS ( SELECT so.item_id AS item_id,
                                   COUNT(*) 
                                      OVER (PARTITION BY item_id
                                            ORDER BY date_time 
                                            RANGE BETWEEN CURRENT ROW AND NUMTODSINTERVAL(10,'MINUTE')FOLLOWING)-1 AS later_records
                              FROM scadainfo_online so)
                       SELECT item_id
                         FROM scadainfo_online
                        WHERE later_records &lt;1)


The 'IN' sub-query is counting records for the id that have occurred between this row and any that are in the following 10 minutes. A row (the current row) is returned if there are no further rows.
Sorry about the description of how it works; I find analytic queries tricky and explaining them even more so.