SQL Server Alert using WMI Event Error

• xXShanXx

  Right there with Babe

  Points: 731

  More actions

  September 22, 2011 at 5:46 am

  #257887

  Hi

  I want to execute a job when ever a file is dropped into a particular folder.

  I found some articles where we can do it on SQL Server.

  I created a alert type: " WMI Event Alert "

  For the name space its the SQL instance which comes automatically as "\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER"

  On the Query section - I wrote the below query ,

  "SELECT * FROM __InstanceCreationEvent WITHIN 1 WHERE TargetInstance ISA 'CIM_DataFile' AND TargetInstance.Name = ‘c:\\TestFolder\’ "

  bit it throws out an error msg

  TITLE: Microsoft SQL Server Management Studio

  ------------------------------

  Cannot create new alert. (SqlManagerUI)------------------------------

  ADDITIONAL INFORMATION:

  Create failed for Alert 'AlertTest'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2425.0+((KJ_PCU_Main).110406-2044+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Alert&LinkId=20476------------------------------An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------

  SQLServerAgent Error: WMI error: 0x80041058.

  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. (Microsoft SQL Server, Error: 22022)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2425&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476

  Can some one please advice me is my Query is correct and is there any thing i need to check out something.

  Thanks a lot in advance.

  Regards

  Shan

• xXShanXx

  Right there with Babe

  Points: 731

  More actions

  September 22, 2011 at 5:50 am

  #1385070

  Hi All

  I even tried this way - using the name space as : \\.\root\cimv2 but no luck

  USE [msdb]

  GO

  EXEC msdb.dbo.sp_add_alert @name=N'SimpleFolderWatcher',

  @enabled=1,

  @delay_between_responses=0,

  @include_event_description_in=0,

  @wmi_namespace=N'\\.\root\cimv2',

  @wmi_query=N'SELECT * FROM __InstanceCreationEvent

  WITHIN 1

  WHERE TargetInstance ISA ''CIM_DataFile''

  AND TargetInstance.Drive = ''M:''

  AND TargetInstance.Extension=''csv''

  AND TargetInstance.Name LIKE ''M:\\2011%'' ',

  @job_id=N'00000000-0000-0000-0000-000000000000'

  GO

  I got this below error :

  Msg 22022, Level 16, State 1, Line 0

  SQLServerAgent Error: WMI error: 0x80041058.

  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.

  First of all - is my Query correct .

  Is there any configuration settings which i need to check for ?

  Thanks a lot in advance .

  Please advise.

  Regards

  Shan