Publishing and consuming messages from a JMS topic

Using the built-in functions msgpublish and msgconsume, Transact-SQL applications can publish messages to, or consume messages from, a JMS topic.

First, you must register a subscription, using sp_msgadmin 'register'. Registering a subscription creates a name that msgpublish, msgconsume, msgsubscribe, and msgunsubscribe functions can reference. Register a subscription as durable or nondurable, and you specify a message selector to control the messages that come in, ensuring that only messages of interest are read.

Use msgsubscribe to tell the JMS provider to hold messages until the application logic is ready to process them. Use msgunsubscribe to tell the JMS provider that the application is no longer interested in messages on this subscription. Use msgunsubscribe to delete durable subscriptions from the JMS provider.

Message properties in read messages can be individually processed by the application logic.