Monitor jobs in SQL Server

[raphael.lage]

Hello. First, sorry for my English. I have several SQL Server 2017 servers and they run several jobs.

I need to monitor these jobs so that I know which job failed to execute. I made a query to feed my zabbix (which is integrated with graphana) sending through zabbix_sender. Up to this point, everything is ok.

But when the alert is generated in zabbix I can not take the job name to trigger, for example: Job Failed to MYSERVER But as there are several jobs on this server, I can not know through the alert which job did not run. How can I take the name of the failed job to trigger on zabbix?

In my query there is the condition that you show me the name and run_status = 0 (0 equals SQL Server failure). Thank you.

[raphael.lage]

Thank you for your help. I was able to do it straight from the graphana. Grafana has an MS SQL Server data source, where you can query directly in grafana. I created the query inside graphana to collect the information I need regarding the jobs, so I was able to monitor the jobs.

[heshammhafez]

Hello Raphael,

Can you please elaborate more how you implemented it, because I have similar issue but I don't know how zabbix can monitor MSSQL jobs