SQLAgent:Jobs-Failed -Jobs in perfmon

  • Hi,

    How to reset perfmon counter "SQLAgent:Jobs-Failed Jobs" without restarting SQLAgent service ?

    Thanks

    Best regards

    Sebastien

  • I am also using the performance counter Failed Jobs _Total and I see 3 jobs failed but when I check Activity Monitor I do not see any failed jobs for the past few days...So this _Total is storing every job that failed since the Agent was started or so I am guessing. I only want to see jobs that failed in say the last 24 hours Is there a way this counter can be reset to 0...Restarting the agent doesn't seem to be the best way to reset counters IMHO...

    Here is what I am using

    perf_counter[\SQLAgent:Jobs(_Total)\Failed jobs]

    Any help would be greatly appreciated...

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

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