Job Failed still active after cluster failovers - Job is OK

SQL Server performance monitoring and alerting

Job Failed still active after cluster failovers - Job is OK

Postby PDinCA » Wed Feb 20, 2013 7:16 pm

Regular patching occurred. The job was running at the time and the detail page states "The job was stopped prior to completion by Shutdown Sequence 0."

SQL Monitor popped up a Medium severity, Job Failure Event.

Patching has been complete for about 12 hours.

The job has executed successfully every 15 minutes since the final fail-back to the preferred node.

SQL Monitor still shows this as an ACTIVE EVENT, which is false.

It appears that SQL Monitor could interrogate the cause of the failure and if it is a "shutdown 0", monitor the next execution for "success" and END the Event.

Would Red Gate please consider this to eliminate future false-positives?

Thanks.
PDinCA
 
Posts: 517
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby priyasinha » Thu Feb 21, 2013 4:22 pm

Hi PDinCA,

Job Failure alerts are event alert i.e. there is no state associated with it. The way they work is that if a job failure happens then SQL Monitor raises an alert. When the next job failure happens then there will be another instance for this alert. This is different from some other alerts like 'Processor utilization' which are continuous alert and have a state associated with them. These alert will remain 'Active' if the alert condition still exists and would be marked as 'Ended'.

Hope this explains it. If you need more information about both these types of alert then you can find it here.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby PDinCA » Thu Feb 21, 2013 6:31 pm

IMO this isn't helpful of SQL Monitor.

If SQL Monitor looked at the next execution and saw it was successful, simply "End" the Event and I won't have to login to the server, fire up SSMS, expand SQL Agent, fire up the Job Monitor, locate the job... See what I mean - a whole load of manual effort for something SO EASY for SQL Monitor to handle...

Enhancement Request hereby lodged - I CANNOT add it to User Voice as I HAVE NO VOTES LEFT :(
PDinCA
 
Posts: 517
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby priyasinha » Mon Feb 25, 2013 10:54 am

Hi PDinCA,

We are checking if we can assign more votes to you.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests