Adding Warning with sp_add_alert doesn't work with "GreaterThan"

  • Hello SQL-Friends,

    yesterday we upgrade our SQL-Server to 2014. Today I miss a warning for replication.

    However, I Have the sp_add_alert Script, looks like this:

    USE [msdb]

    GO

    EXEC msdb.dbo.sp_add_alert @name=N'MAN more than 1000',

    @enabled=1,

    @delay_between_responses=0,

    @include_event_description_in=1,

    @performance_condition=N'Replication Dist.|Dist:Delivered Cmds/sec|MyFancyReplication|>|1000',

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

    GO

    When I execute this, I get this warning (translated because the original is german)

    A performance condition must be formatted as: ‘object_name|counter_name|instance_name|comparator( or < or =)|numeric value'.

    Did you recognize the missing "greater than" in the error message? There is just " " than or and so on...

    I've checked the MSDN for an answer. (http://msdn.microsoft.com/en-us/library/ms189531.aspx)

    The @performance_condition can be >, < or =

    So, whats the problem?

    Best Regards

    Björn

Viewing 0 posts

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