Send an Email when a particular SQL Server Job Fails using SCOM Subscriptions
Hi All,I have created a Group which has explicit members as
( Object is SQL 2000 Agent Job AND ( Job Name
Equals 123729M2k ) AND True ) and have created a subscription i.e. whenever An alert is raised in scom an email should be send to a particular user this is not working and I want to subcribe to a specific sql jobs , Is there a way to setup this thing correctlyThanks
March 9th, 2010 7:13pm
Hi,
I'm having a similar issue - did you ever figure it out?
Thanks,
Lee
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2010 2:12pm
Hi there. Have you enabled discovery of SQL 200x Agent Jobs?Layne
April 14th, 2010 6:26pm
Hi Jatinder
Did you get this working? If you need further assistance let us know and I'll try and test this.
Cheers
GrahamView OpsMgr tips and tricks at
http://systemcentersolutions.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2010 2:14pm
Hi, Try going to Authoring, Monitors, SQL 2008 Agent Job, Entity Health, Availability, Last Run Status. Override the Last Run State Monitor so that the parameter "Alert On State" Override Value is "The Monitor is in a Warning State" On your Subscription
Criteria use Last Run Status and the set specific severity as Warning. Good luck! :) Cheers, Lee
April 22nd, 2010 2:26pm
Hi
I am getting the same issue ... seems to be a problem with the MP maybe. I went as far as setting a subscription to fire off on any "Warning" Severity. All my Warnings were picked up by the subscription, except for the "Last Run Status" Alerts. Other than
that I have tried about 15 different techniques to get this working with zero luck.
If anyone has success pls post, cos this is a great monitor
Thanks
Ryan
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2010 12:18pm
Hi, I will "mark as answer" as no activity for a long time, feel free to re-open this thread. ThanksAnders Bengtsson | Microsoft PFE | blog at http://www.contoso.se
December 22nd, 2010 9:18am