How to clear suspended messages

TIMOTHY STEVENS 0 Reputation points
2023-08-25T19:28:08.9733333+00:00

I would like to have an automated process that terminates and deletes all suspended messages regardless of whether or not they can be resumed. I am assuming that a stored procedure could be written to do this and then scheduled on the database server with the SQL Agent Jobs.

Thanks in advance for any help, or advice you are able to give.

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
358 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Colin Dijkgraaf 1,346 Reputation points
    2023-08-27T23:24:59.9466667+00:00

    Just enable routing for failed messages on the ports and have a send port subscribing to failed messages. Then they will be automatically removed.

    0 comments No comments