question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked bharathn-msft commented

Capture SQL Agent Failed Jobs via Azure Log analytics

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 ??*

129934-image.png



azure-monitor
image.png (27.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MSTechie-7364 - Apologies for delay in getting to this thread, will review your scenario and get back to you to share learnings.

0 Votes 0 ·

0 Answers