Queries for the AmlComputeJobEvent table
For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
Get failed jobs
Get top 100 failed jobs.
AmlComputeJobEvent
| where EventType == "JobFailed"
| project TimeGenerated, ClusterId, EventType, ExecutionState, ToolType, JobErrorMessage, ErrorDetails
| limit 100
Get records for a job
Get top 100 records for a specific job name.
AmlComputeJobEvent
| where JobName == "automl_a9940991-dedb-4262-9763-2fd08b79d8fb_setup"
| project TimeGenerated, ClusterId, EventType, ExecutionState, ToolType
| limit 100
Display top 5 longest job runs
Display top 5 longest job runs.
AmlComputeJobEvent
| where OperationName == "JobSubmitted"
| join kind = inner (AmlComputeJobEvent
| where OperationName == "JobSucceeded"
| project StopTime=TimeGenerated, JobId)
on JobId
|project Duration=(StopTime-TimeGenerated), ExperimentName, WorkspaceName, ClusterName, JobName
|top 5 by Duration desc nulls last