Create WMI Alert

  • Hi,

    I have server with Windows server R2 and SQL 2014 SP1.

    I tried to create a WMI Alert

    USE [msdb]

    GO

    EXEC msdb.dbo.sp_add_alert @name=N'Alert System : System : Processor Queue Length > 20',

    @enabled=1,

    @delay_between_responses=0,

    @include_event_description_in=0,

    @wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER',

    @wmi_query=N'SELECT * FROM __InstanceModificationEvent WITHIN 10 WHERE TargetInstance ISA "Win32_PerfFormattedData_PerfOS_System" AND TargetInstance.ProcessorQueueLength > 20'

    I got a error message :

    Msg 22022, Level 16, State 1, Line 0

    SQLServerAgent Error: WMI error: 0x80041003.

    Msg 14511, Level 16, State 1, Procedure sp_verify_alert, Line 300

    The @wmi_query could not be executed in the @wmi_namespace provided. Verify that an event class selected in the query exists in the namespace and that the query has the correct syntax.

    Any idea to fix the issue.

    I ran WMIDIAG on server (see reports). I saw some errors but I don't know if it's the main reason of issue.

    Thanks

    Eric

Viewing post 1 (of 1 total)

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