Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

WMIEventProviderNotificationQueue Expand / Collapse
Author
Message
Posted Tuesday, October 2, 2012 8:06 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:13 AM
Points: 590, Visits: 1,579
Hi all

Being new to Service broker I am just trying to understand a couple of points. I am using WMI to automatically create an event notification by creating an alert.

One thing I don't understand is when the notification is sent to the queue I have seen it disappear automatically. What is doing this as I thought you had to set an activation of some sort, is this just a built in SQL thing?

Thanks
Post #1367063
Posted Wednesday, October 3, 2012 6:08 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:22 PM
Points: 411, Visits: 1,399
First off, I do not have any experience with WMIEventProviderNotifications, but I have worked a lot with Service Broker, so I may be totally off, but I think I can still answer this question for you. If I read this msdn article correctly, you are not supposed to read this queue yourself. The WMI provider (which is, according to the article, implemented as a SQL Agent job) reads the items from this queue. The WMI provider seems to provide an API so that WMI-capable clients can query SQL server properties and be notified of any changes therein. Service broker seems to be involved only internally to implement this WMI provider.



Posting Data Etiquette - Jeff Moden
Posting Performance Based Questions - Gail Shaw
Hidden RBAR - Jeff Moden
Cross Tabs and Pivots - Jeff Moden
Catch-all queries - Gail Shaw


If you don't have time to do it right, when will you have time to do it over?
Post #1367597
Posted Wednesday, October 3, 2012 11:34 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:13 AM
Points: 590, Visits: 1,579
ok fair enough thanks
Post #1367887
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse