Hello,
We are using Wm v9.9. This came up because we were bouncing around ideas to handle reprocessing. One idea is to place a message into a queue that failed to send originally. After that a job will run say every hour that triggers a service to pick up those messages and attempt to send them again. If they fail again they are placed back into the original queue they were picked up from.
Without some sort of selector, if the messages continue to fail when sending the service will be stuck in a loop continually picking up the message, trying to send, failing, and then picking up immediately again. Selecting by an age timestamp would help prevent this.
Is it possible to do? Is there a reason some SQL92 commands do not work despite the doc saying they should?
Thank you,
Chris