Azure SQL Managed Instance - Agent Jobs monitoring with Dynatrace SQL Extension

[kayjayeff1]

Based on the current SQL Extension documentation it doesn't look like it can monitor Azure SQL Managed Instance SQL Agent Jobs.  In the attached screenshot it references "SQL Server (all versions)"; however, in other sections of the doc "SQL Managed Instance" is called out separately. 

I am looking for confirmation that the SQL Extension can, or cannot, monitor SQL Agent Jobs for Azure SQL Managed Instance DBs.  Any guidance would be appreciated.

Thanks.

-k.

[sujit_k_singh · Accepted solution]

@Hello @kayjayeff1 

The official Dynatrace SQL Extension documentation calls out SQL Server (all versions) for job monitoring, but does not explicitly confirm Azure SQL Managed Instance. In practice If your Managed Instance exposes msdb.dbo.sysjobs and related tables, the extension should work.
If the Managed Instance restricts access or disables certain Agent features, the extension will return empty results.

[kayjayeff1]

@sujit_k_singh we THINK it will work, but have not gotten the POC to test it off the ground yet.  I will report back on the results once complete 🙂 

[kayjayeff1]

We were able to get our connection working yesterday and we are indeed able to gather SQL Server Agent Job history from the Azure SQL Managed Instance.