SCOM- mssql agent job status for DB servers

Hi Team,

I have request for creating report for all db servers mssql agent job status. Can someone help me on this ?

1 Like

I would enable the discovery of SQL agent jobs and then display them on a dashboard. Would that work?
Example:

1 Like

Do we have any sql query to get this data for reporting