Red Gate forums :: View topic - Job Failed still active after cluster failovers - Job is OK
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Job Failed still active after cluster failovers - Job is OK

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PDinCA



Joined: 25 Jul 2005
Posts: 512
Location: Costa Mesa, CA, USA

PostPosted: Wed Feb 20, 2013 7:16 pm    Post subject: Job Failed still active after cluster failovers - Job is OK Reply with quote

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.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Thu Feb 21, 2013 4:22 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 512
Location: Costa Mesa, CA, USA

PostPosted: Thu Feb 21, 2013 6:31 pm    Post subject: Reply with quote

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 Sad
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Mon Feb 25, 2013 10:54 am    Post subject: Reply with quote

Hi PDinCA,

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

Thanks,
Priya
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group