Red Gate forums :: View topic - Job Failed alert is not raised for some jobs that fail
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 alert is not raised for some jobs that fail

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



Joined: 26 Jun 2013
Posts: 2

PostPosted: Wed Jun 26, 2013 6:40 pm    Post subject: Job Failed alert is not raised for some jobs that fail Reply with quote

I've noticed that some jobs don't raise an alert when they fail. I suspect it has to do with whether or what sort of error code is returned, but so far I've been unable to find the difference between jobs failures that raise the alert and ones that don't.

Here are two examples of recent job failures that didn't raise an alert:
1) transaction log backup failed because it was missing a full backup.
2) DBCC CHECKDB reporting consistency errors for a database.

I've verified that run_status = 0 in sysjobhistory, and that the job step is configured to "quit the job reporting failure" when the step fails. Both jobs are part of Maintenance Plans, but failures of those types of jobs have raised the alert before.

So I really have a two-part question.

First, why aren't these job failures triggering the "job failed" alert? i.e. what's different about them?

Second, and more importantly, how can I get alerts on them in the future? I really do want to know when log backup fail or I have consistency/corruption issues with databases. Basically, if I see a "red X" icon in the job history via SSMS, I think I'd like to get an alert via SQL Monitor.

Thanks
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Thu Jun 27, 2013 1:13 pm    Post subject: Reply with quote

Hi Matt,

SQL Monitor should notify you for all jobs which had run_status of anything other than 1.

The only issue I can think of is that we had a bug with job failure alert pre v3.4 release where it wouldn't notify of some job failures. The description of the bug can be found in release notes against bug number SRP-8159.

If you are experiencing this issue in v3.4 or later then I would suggested to raise a support request at support@red-gate.com so that we could investigate it.

Thanks,
Priya
Back to top
View user's profile Send private message
Matt



Joined: 26 Jun 2013
Posts: 2

PostPosted: Thu Jun 27, 2013 4:44 pm    Post subject: Reply with quote

Hi Priya,

That bug-fix looks like it applies to at least one of the failed jobs, so I'll go ahead and upgrade to 3.4. If I'm still having issues with the other job after that, I'll escalate to support.

Thanks for your help.
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