Since three weeks, I have been struggling to figure out the root cause of one of the error's that i am currently facing in IDERA DM,
When enabled the metric "SQL Server Status", the below error is thrown to a specific set of instances.
SQL Server instance ******* – The SQL Server service status is: Unable To Monitor.
[********] Error interpreting Job Alerts Collector: Invalid column name 'job_last_run_duration'.
I made sure the version of IDERA is upgraded to latest CU, all the monitoring services are up and running.
I also reached out to Support and they think it's a bug and escalated to development team, while i am waiting for their response i thought to post it in this forum to see if anyone encountered similar issue and has any idea to troubleshoot it.