How to clear dm_aq ?
Hi,
We have dm_aq configured in BRM to push notification from BRM to Siebel via AIA.
We have batch script written in brm with below SQL which check the count of records in Aq_SYNC table .
SQL:
select count(*) from AQ_SYNC where state<>2 and state<>3 order by enq_time desc;
If the count is greater than 0 it doesn't allow further process to be called written in the script.
so please do help me know how should i clear this queue in brm ? so that further process should be called.