My SQL Server 2017 is on Azure VM (IaaS option). This has SQL Agent running.
Now i want to monitor the SQL Agent Jobs which are failed in the last 10 mins.
My Azure VM is connected to the Log analytics and in Azure Log analytics , we have the option in Performance counters to check the list of SQL Agent jobs , which has failed via the below counter
**SQLAgent:Jobs()\Failed jobs .. Does this performance counter only apply to Azure SQL PaaS options like Azure Managed Instance or does it apply to SQL Server on Azure VM ? Basically i want to capture failed agent jobs on Azure VM having SQL.Server. So can i use this performance counter ??*