SCOM- mssql agent job status for DB servers

SCOM_user · September 23, 2021, 4:59am

Hi Team,

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

jannep · September 24, 2021, 1:34pm

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

SCOM_user · September 27, 2021, 5:17am

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