Check MSSQL health with JOBS focus

picoroma · February 8, 2025, 4:49pm

I need to check the HEALTH of MSSQL on WINDOWS server.
“Icinga for Windows” already in place so I wan to try to use this plugin.

I saw that Icinga for Windows can be enhanced with some PS module to check the Health of MSSQL.
https://icinga.com/docs/icinga-for-windows/latest/mssql/doc/plugins/02-Invoke-IcingaCheckMSSQLHealth/

But there is no “check” for the Scheduled JOB Status .
I’m interested to be alerted if a scheduled JOB fails.

I found this NAGIOS plugin:

github.com

yosbit/nagios-plugins/blob/master/README/README_check_mssql.md

[![Donate](https://www.paypalobjects.com/en_US/IL/i/btn/btn_donateCC_LG.gif)](https://paypal.me/yosbit)
## Description:
Script for nagios to check SQL DataBases, Connection Time, Jobs, TempDB Size, Log Size.
The script get all sql instances in the server, and return status for eache instance
You can use check_mssql_config.ini to exclude DB or instance to check, read check_mssql_config.ini help.

## Auther:
  Yossi Bitton yosbit@gmail.com
  Date: November 2018 
  Version 1.1.2

### PARAMETER DBStatus
Get the database status, return critical if one DB not in normal state.

### PARAMETER ConnectionTime
Get the time to connect to DB, include performance data.

### PARAMETER Jobs
Get the status off all jobs, the script check only Enabled and scheduled jobs.

This file has been truncated. show original

Is there a way to integrate this check into “Icinga for Windows” in order to check also the JOB ?
IDEAS ?
P.

lorenz · February 11, 2025, 7:41am

Hi @picoroma,
Well, if the functionality is useful, there is a chance to get this integrated. Could you open an Issue for that in the development repository?
That would be the best location for that, the developers would see it and so forth.
Ideally you could contribute an implementation of your idea directly!

picoroma · February 11, 2025, 8:02am

OPEN:

github.com/Icinga/icinga-powershell-mssql

FEATURE request: Check MSSQL health with scheduled JOBS focus

opened 08:01AM - 11 Feb 25 UTC

picoroma

I need to check the HEALTH of MSSQL on WINDOWS server. “Icinga for Windows” alre…ady in place so I wan to try to use this plugin. I saw that Icinga for Windows can be enhanced with some PS module to check the Health of MSSQL. **https://icinga.com/docs/icinga-for-windows/latest/mssql/doc/plugins/02-Invoke-IcingaCheckMSSQLHealth/** But there is no “check” for the Scheduled JOB Status . I’m interested to be alerted if a scheduled JOB fails. I found this NAGIOS PLugin: **https://github.com/yosbit/nagios-plugins/blob/master/README/README_check_mssql.md** That can be used as a "base" to create some more PS script to monitor MSSSQL and the Schedult JOB od MSSQL itself. Any Idea ?

THX
P.

picoroma · March 6, 2025, 4:58pm

Is there a WAY to call on a remote Windows server with “Icinga 4 Windows” installed a .ps1 script from ICINGA Master ?
How should the “command” be defined ?
P.