April 18, 2010 at 8:10 pm
Hi,
I'm working with SCOM 2007 R2 to monitor some database servers, and I have just enabled SQL Job Duration monitoring.
As the database backups are done via SQL jobs, the default thresholds for this alert is not enough. All the database backup SQL Jobs have the same name "database backups" on multiple servers.
What I'm after finding out is if we can setup an override for the Job Name across multiple SQL servers - to increase the lower and upper thresholds - without having to set each server manually.
Has anyone done this before?
April 19, 2010 at 7:03 am
You won't be able to disable by job across multiple servers in one step. Probably the best way to do it would be to write a PowerShell script that walked through all your servers disabling the job by name.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2010 at 6:53 pm
Hi,
I didnt want to disable the thresholds - just "group" them - which is precisely what I did and it worked! I created a group, with dynamic members, query formula being "Object is SQL Job Agent and Job Name contains "Backups" - then when the alert came up for the job I added the override for that to the group - and it works perfectly! 😉 Might help some others out there 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply