An extension of the existing MSSQL by ODBC template that also monitors failed SQL Agent jobs.

Prerequisites: MSSQL by ODBC template should be configured and running on host

It monitors runstatus, duration, nexrundatetime, nexrunstatusmessage, lastrundatetine, enabled but only runstatus, duration and enabled are created at discovery as standard to save database size but can be enabled on hosts needed.

It currently only discover enables jobs

Zabbix sql monitor user configured in the MSSQL by ODBC template needs the following permissions:

USE msdb
CREATE USER [zabbix] FOR LOGIN [zabbix]
GRANT SELECT ON OBJECT::msdb.dbo.sysjobsteps TO zabbix
GRANT SELECT ON OBJECT::msdb.dbo.sysjobs TO zabbix
GRANT SELECT ON OBJECT::msdb.dbo.sysjobhistory TO zabbix
GRANT SELECT ON OBJECT::msdb.dbo.sysjobschedules TO zabbix
GRANT SELECT ON OBJECT::msdb.dbo.syscategories TO zabbix
GRANT SELECT ON OBJECT::msdb.dbo.log_shipping_monitor_secondary TO zabbix
GRANT SELECT ON OBJECT::msdb.dbo.log_shipping_monitor_primary TO zabbix
GRANT SELECT ON OBJECT::msdb.dbo.sysjobhistory TO zabbix

I also included the actual MSSQL by ODBC template with backup monitor integrated in it. This will monitor if missing SQL Backups.