Hello,
i have a big problem i'm searching now for a long time and can't find anything.
I Always get the following error in Nagios Core:
[08-19-2021 07:25:01] SERVICE ALERT: XAL164;SQL Jobs;CRITICAL;SOFT;3;CRITICAL - Number of failed jobs: 1 - Failed Jobs: Monitoring_QueryExecutionTime.Subplan_1 last run at 08/19/2021 07:00:00
Thats a "known" issue on the SQL Server but i need to Exclude that one single job from the monitoring.
Is there any way that i can exclude this? Please let me know.
Here is the Check:
define command {
command_name check_sqljobs
command_line $USER1$/check_mssql_job_history.py -H $HOSTADDRESS$ -U nagios -P nagios
}
And here the Service:
define service{
use local-service ; Name of service template to use
hostgroup_name sql-hosts
service_description SQL Jobs
check_command check_sqljobs
}
Thanks in advance
Exclude one single SQL Job
Re: Exclude one single SQL Job
Looks like this plugin has an exclude argument baked-in:
https://bitbucket.org/jetole/mssql-job- ... y#lines-67
Could try adding -x Monitoring_QueryExecutionTime.Subplan_1 to your command definition's command_line.
https://bitbucket.org/jetole/mssql-job- ... y#lines-67
Code: Select all
parser.add_argument("-x", "--exclude", action="store", help="A comma seperated list of jobs not to check", dest="exclude");
Former Nagios employee
https://www.mcapra.com/
https://www.mcapra.com/
-
- Posts: 2
- Joined: Wed Dec 16, 2020 9:57 am
Re: Exclude one single SQL Job
Thanks a lot
That fixed my problem.
That fixed my problem.