Forum Discussion

null null's avatar
null null
Copper Contributor
Oct 05, 2017

SQL Azure OMS-Job Monitoring

Hello Team,

 

I am using OMS portal to get the failure notification for runbook failure created under Azure automation account. I have used below query to set the alert and getting failure notification as an email. However the challenge is, I am not getting NAME of job in the email notification.

 

Type=AzureDiagnostics ResourceProvider="MICROSOFT.AUTOMATION" Category=JobStreams StreamType_s=Error | measure count() by JobId_g

 

Let me know if anyother query or any other solution which can help me to identify the job name during email notification. I am attaching the image of email notification.

 

-- Kailash Jain.

 

  • Hi Unfortunately this is not possible. If you switch to the new query language there could be some workaround by concatenating the name and the jobID and than aggregate on the new concatenated value.
  • Hi Unfortunately this is not possible. If you switch to the new query language there could be some workaround by concatenating the name and the jobID and than aggregate on the new concatenated value.

Resources