FEATURE request: Check MSSQL health with scheduled JOBS focus

[picoroma]

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:
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 ?

[RincewindsHat]

Hello again @picoroma :-)
Just to satisfy my curiosity, could you explain what a "Scheduled Job" in MSSQL is and how
one can determine whether something is "good" or "bad"?

[picoroma]

I'm talking about "SQL Server Agent Job" and more in details abount " Notification regarding Job Status (fails or error)
More info: https://learn.microsoft.com/en-us/sql/ssms/agent/configure-sql-server-agent?view=sql-server-ver16