Change column value status to be interrupted if no new record return after 10 mins
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.