Post reply

WMIEventProviderNotificationQueue

  • October 2, 2012 at 8:06 am

    #267560

    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

  • October 3, 2012 at 6:08 am

    #1544839

    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[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

  • October 3, 2012 at 11:34 am

    #1545086

    ok fair enough thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply