You are hereSupport / Known Issues / 6.2 Jobs Failed Filter Does Not Work Correctly SQL2005
6.2 Jobs Failed Filter Does Not Work Correctly SQL2005
If you're not able to filter failed jobs in SQL2005 or SQL2008 collections, the following will fix the problem:
- Download the patched firenze-collectors.jar file.
- Stop the Longitude Services with services.msc.
- Rename the extension for Longitude\dc\lib\firenze-collectors.jar and copy the downloaded file into its place.
- Start the Longitude Services back up.
- Filter the services in the Failed Jobs collector
I am trying to configure action rules for specific SQL 2005 FailedJobs jobs by specifying the name of the job as configured in Management Studio for the SQL Server Agent in the Action Rule's "Measured Object" text box.
The Action Rule does not activate and send out an email as configured when the relevant SQL2005 agent job fails.
Is this failure likely due to the issue as described here if the patch has not been applied?
Please send over a screenshot of the event you are seeing in the event monitor when this job fails, please also send over a screenshot of your action rule configuration.
Please send these screenshots to support@heroix.com
I found that I could simply use the wildcard character "*" in the Action Rule's "Measured Object" text box and any individual failed job is identified by name in the email send out in the action item, so I have started using that instead of creating individual action items for each SQL Agent job.
I just created one job-specific Action Rule as a test. In this case, I had a recent occurrence of a job failure displayed in the event monitor to confirm the Measured Object name to use. Through this test I was able to confirm that a properly configured Action Rule with specification of a particular SQL Agent job name DOES work properly.
My theory to explain the previously observed failures is there must have been something about the job name entered in the Action Rule's "Measured Object" text box in those previous configurations that interfered with the ability of Longitude to associate the rule with the object failure.
I noticed that these object names are always presented in lower case in the event monitor. Should the object names entered in the Action Rule's "Measured Object" text box always be in lower case to enable proper association of the rule with the object?
Yes all measured objects appear in lowercase in the Event Monitor so they should be lower case in the action rules.
