Nagios Support Forum

The SQL Server Plugin the one that produces these: MSSQL Average Wait Time Problem has been acknowledgedThis service problem has been acknowledgedNotifications are disabled for this service Critical 19d 12h 24m 22s 5/5 2016-03-30 09:34:16 CRITICAL: Average Wait Time (ms) is 64.5395894428ms MSSQL Dat...

Hi Nagios Community, I was wondering if there is anyway to set custom thresholds for SQL Server Plugins. For instance I'm getting alerts about: MSSQL Lock Requests Per Sec MSSQL Lock Wait Times MSSQL Page Looks Per Sec MSSQL Stolen Pages MSSQL Target Pages Is there anyway to set custom thresholds fo...

I found it and removed it. I then did a and it stopped and started cleanly. Is this where I should be putting the service definition? Or is there a better way of handling this?

Thanks Again,
Regards,
Bryan

Sorry, stupid on my part,
[root@localhost etc]# grep -R 'Failed_Jobs' /usr/local/nagios/etc/
/usr/local/nagios/etc/services/10.32.35.180.cfg: service_description Failed_Jobs

[root@localhost etc]# grep -R 'Failed_Jobs' /usr/local/nagios/etc/? grep: /usr/local/nagios/etc/?: No such file or directory [root@localhost etc]# cd / [root@localhost /]# grep -R 'Failed_Jobs' /usr/local/nagios/etc/? grep: /usr/local/nagios/etc/?: No such file or directory [root@localhost /]# cd /u...

No I switched out the old command for job failed with this one: define command{ command_name check_mssql_job command_line $USER1$/check_mssql_job_history.py -H $HOSTADDRESS$ $ARG1$ } I'm wondering where else I should look for this definition? Sorry for the newbie question, Bryan

I'm trying to remove the old service command definition for the old java class that I was using and replace it with the new service/command definition I have here. I remember reading over the docs to figure out how to do this, and somehow I did but I can't remember what it was I did? Checking object...

I'm assuming $User1$ expands to /usr/local/nagios/libexec
-H $HostAddress$ expands to my IP or I have to replace it?
-A $Args1$ is going to expand to what is in command_name? I'm new to this so please forgive me if my questions are stupid.

This looks great but where do I put it? In /usr/local/nagios/libexec ? Should it use a file extension? Sorry I'm new to Nagios.

./check_mssql_job_history.py -H msqlHost -U mssqlUser -P mssqlPassword