Supported metrics for Microsoft.Sql/servers/jobAgents
The following table lists the metrics available for the Microsoft.Sql/servers/jobAgents resource type.
Table headings
Metric - The metric display name as it appears in the Azure portal.
Name in Rest API - Metric name as referred to in the REST API.
Unit - Unit of measure.
Aggregation - The default aggregation type. Valid values: Average, Minimum, Maximum, Total, Count.
Dimensions - Dimensions available for the metric.
Time Grains - Intervals at which the metric is sampled. For example, PT1M indicates that the metric is sampled every minute, PT30M every 30 minutes, PT1H every hour, and so on.
DS Export- Whether the metric is exportable to Azure Monitor Logs via Diagnostic Settings.
For information on exporting metrics, see - Metrics export using data collection rules and Create diagnostic settings in Azure Monitor.
For information on metric retention, see Azure Monitor Metrics overview.
| Category | Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Basic | Elastic Jobs Executions Failed Number of job executions that failed while trying to execute on target |
elastic_jobs_failed |
Count | Total (Sum), Count | <none> | PT1M | Yes |
| Basic | Elastic Jobs Executions Successful Number of job executions that were able to successfully execute on target |
elastic_jobs_successful |
Count | Total (Sum), Count | <none> | PT1M | Yes |
| Basic | Elastic Jobs Executions Timed Out Number of job executions that expired before execution was able to finish on target. |
elastic_jobs_timeout |
Count | Total (Sum), Count | <none> | PT1M | Yes |