How to use regex pattern in exclude list for agent_job_failure checkpoint

Document ID:  TEC1874877
Last Modified Date:  06/06/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Unified Infrastructure Management

Releases

  • CA Unified Infrastructure Management:Release:8.4
  • CA Unified Infrastructure Management:Release:8.47
  • CA Unified Infrastructure Management:Release:8.5
  • CA Unified Infrastructure Management:Release:8.51

Components

  • UIM - SQLSERVER:UIMSQS
  • UNIFIED INFRASTRUCTURE MGMT:CAUIM
Introduction:

This document would explain a way to exclude the job failure alerts from the agent_job_failure checkpoint for sqlserver probe

When we have multiple jobs running on sqlserver probe where we would not need all of them to be monitored and need to exclude them from monitoring though the jobs are failing.

Question:

How to use regex pattern in exclude list for agent_job_failure checkpoint

Environment:
UIM: 8.31, 8.4 and later.
Answer:

1. Created four jobs in SQL Server and job runs for every 2 minutes

                                      1.jpg

2. Configured agent_job_failure checkpoint with threshold of 5 minutes and check_interval as 2 minutes.

                                     2.jpg

3. Below are the alarms raised for the job failures.

                                      3.jpg

4. Adding regex to exclude the particular job for monitoring using this checkpoint. Where we need to exclude based on the object type however we do not have feasibility of filtering using job name currently, which would be an IDEA or enhancement request in communities.ca.com

                                     4.JPG

                                     5.JPG

5. We need to click "yes" to restart the probe after the changes.

6. Job alerts showing after enabling the exclude list. 

                                     6.JPG

 

 

Additional Information:

Reference:

http://wiki.sup.fco/index.php/Sqlserver_probe#Include_and_exclude_Objects

How to submit an Idea (Feature Request) to the CA UIM User Communities

http://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec000004993.html

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >