Next processed message by SFM
                                                 Last update (2008-03-03 13:08:01)
                                                                                                                   Date added (2008-03-03 13:07:25)

Summary
To find the next message that will be processed by SFM, based on priority and enq_time, execute
SELECT a.user_data.message_id message_id, a.corrid message_type
FROM xnp.xnp_in_evt_qtab a
WHERE priority = (SELECT MIN(priority) FROM xnp.xnp_in_evt_qtab d)
AND enq_time = (SELECT MIN(enq_time) FROM xnp.xnp_in_evt_qtab c
WHERE c.priority=a.priority)
AND step_no = (SELECT MIN(step_no) FROM xnp.xnp_in_evt_qtab b
WHERE b.enq_time = a.enq_time
AND b.priority = a.priority);
Reviews
Filters
Search