Create Alert based on output from SQL Script

All replies

• 

  

  0

  Sign in to vote

  Hi Sir,

  >>One important criteria is that the script needs to know when it was last run so that it won't return duplicate alerts.

  I assume monitor covers your needs .

  If it is possible , I'd suggest you to use VB script to do that , because the default script language is VB .

  Please check the following article regarding Two state monitor VB SQL query script :

  http://systemcenter.no/?p=190

  And, this article explained VB SQL query script :

  http://www.4guysfromrolla.com/webtech/faq/databases/faq4.shtml

  ALso, this similar thread:

  https://social.technet.microsoft.com/Forums/systemcenter/en-US/d6f98c38-0454-4dfc-9d85-7dd74d00f83f/alert-from-results-of-sql-query?forum=operationsmanagergeneral

   

  In addition, two state powershell monitoring :

  http://scug.be/dieter/2014/04/24/scom-creating-a-powershell-script-monitor-with-silect-mpauthor/

  And, using PS to connect to SQL and query :

  https://technet.microsoft.com/en-us/magazine/hh855069.aspx

  Hope it is useful to you .

  Best Regards,

  Elton

  ---

  Please remember to mark the replies as answers if they help and unmark them if they provide no help.
  If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

  Monday, September 19, 2016 1:42 PM
• 

  

  0

  Sign in to vote

  Thanks for the reply, it answers my question perfectly.

  Unfortunately, I realised soon after that an alert wouldn't work as I hoped.

  I am collecting failed jobs from a SQL table, so I think this is a rule.  I'm looking into rules now.

  Monday, September 19, 2016 3:03 PM
• 

  

  0

  Sign in to vote

  Similar to other post - this runs through creating this:

  https://blogs.technet.microsoft.com/stefan_stranger/2010/01/21/opsmgr-sql-full-or-differential-backup-check/

  Regards

  Graham

  ---

  Regards Graham Senior Premier Field Engineer (UK) - System Center Operations Manager

  • Proposed as answer by Elton_Ji Wednesday, October 12, 2016 8:17 AM
  • Marked as answer by Elton_Ji Wednesday, October 12, 2016 3:48 PM

  Thursday, September 22, 2016 5:41 PM