Finding the Friendly Name of a MOM Rule
Had a situation with a customer where a custom response he added was generating a storm,and bringing down the MOM service in the process. His question...How do I find out which rule is causing the problem? Our 1st stop was the Application Event Log on the MOM server, where we found this message: In order to avoid excessive load on the MOM Server, this rule will be temporarily disabled until 12/12/2005 13:40:04. Rule: {1B4662D0-6CB7-4F86-988D-25F8565D8FB7} - Custom response execution is disabled To identify the friendly name of the rule, run the following query against the Onepoint database. 1. Launch SQL Query Analyzer. Set the database to Onepoint 2. Paste the following query into the Query Analyzer window. select * from onepoint.dbo.ProcessRule where idProcessRule= 3. Click the green arrow or hit F5 to run the query. The friendly name of the rule will be in the Name column in the query output. |
Comments on "Finding the Friendly Name of a MOM Rule"
-
OfficeGuyGoesWild said ... (5:32 PM) :
post a comment links to this postthanks,
I have found with my MOM server that I need to use dbo.ProcessRule as the tablename, and that I need the ' character at each end of the GUID, and the selecting just the Name field works better. i.e:
select Name from dbo.ProcessRule where idProcessRule='3625894A-BF8B-4D03-A259-0986E4F2B3FD'
Regards.. Marty
www.TheScriptLibrary.com