Exclude one single SQL Job

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Fabian.Walcher
Posts: 2
Joined: Wed Dec 16, 2020 9:57 am

Exclude one single SQL Job

Post by Fabian.Walcher »

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 ;)
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: Exclude one single SQL Job

Post by mcapra »

Looks like this plugin has an exclude argument baked-in:
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");
Could try adding -x Monitoring_QueryExecutionTime.Subplan_1 to your command definition's command_line.
Former Nagios employee
https://www.mcapra.com/
Fabian.Walcher
Posts: 2
Joined: Wed Dec 16, 2020 9:57 am

Re: Exclude one single SQL Job

Post by Fabian.Walcher »

Thanks a lot :)
That fixed my problem.
Locked