FAQShop.com : Scripting MOM to Takeover from ‘Other’ Monitoring Solutions

Scripting MOM to Takeover from ‘Other’ Monitoring Solutions

I'm just starting to dig into MOM, and something I wanted to find out early is whether it can duplicate a couple of app-specific functions we have in our existing (home-grown) monitoring system.

Many of our monitors are database queries that look for specific problems. For example, we check a scheduling service by looking for rows that have passed their scheduled time without being processed. Another is that we check the space usage of our database file groups so that we can track growth over time of data vs. indexes vs. logs, etc. Also, we frequently capture the result of the query (for example, the exact rows that missed their scheduled processing window) and include it in the alert email, plus save it on the database for archiving and later reporting.

So, I'm looking through the scripting documentation and wondering how close I can get with MOM to doing this?

From the microsoft.public.mom newsgroup
You should be able to do this in a timed response script using ADO to query the database for the information you need. The script can create a MOM event (using the 'ScriptContext.CreateEvent' method) to publish the results of the test when it fails. A separate event processing rule would watch for these events and respond appropriately with a alert, notification, etc.