开发者

Service broker queue message arrived but notification doesn't work

开发者 https://www.devze.com 2023-03-08 19:32 出处:网络
I am using the External Activator provided by Microsoft to monitor service broker queue messages. The main queue\'s name is \"ReportQueueTarget\". I also set up a notification queue like this:

I am using the External Activator provided by Microsoft to monitor service broker queue messages. The main queue's name is "ReportQueueTarget". I also set up a notification queue like this:

CREATE QUEUE ReportExternalNotifyQueue
GO
-- create event notification service
CREATE SERVICE ReportExternalNotifyService
      ON QUEUE ReportExternalNotifyQueue
      (
            [http://schemas.microsoft.com/SQL/Notifications/PostEventNotification]
      )
GO

-----------------------------------开发者_如何转开发------------------------------------------
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------

CREATE EVENT NOTIFICATION [ReportNotification]
ON QUEUE [ReportQueueTarget]
FOR QUEUE_ACTIVATION
TO SERVICE 'ReportExternalNotifyService','current database'
GO

This works fine for the two environment I set up. However, for this new environment I am setting up now, message successfully arrive in the main queue, but nothing ever shows up in the notification queue. Therefore, the external activator never receives and notification. What could cause this problem?

Thanks!


I just stumbled upon this question, and I know it's old. If anyone is having the same problem I have a blog post about how to troubleshoot external activation issues.

SQL Server Service Broker troubleshooting external activation

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号