Azure SQL Elastic Job Agent

Available Metrics

Possible metric types that can be tracked on a given resource.

Metric Type Data Type Description
AggregatedMetric
Object
Allows for aggregating existing metrics over a period of time. Useful for running sums or averages; also for extracting single data item from collection-based metrics
AzureAdvisorHealthMetric
AzureAdvisorHealth
AvailabilityState String
Summary String
ReasonType String
ReasonChronicity String
DetailedStatus String
OccuredTime DateTime
ReportedTime DateTime
Tracks Azure health using latest Azure Health API - more info @ https://docs.microsoft.com/en-us/rest/api/resourcehealth/availabilitystatuses/getbyresource/
AzureAdvisorRecommendationMetric
AzureAdvisorRecommendation[]
Category String
Impact String
LastUpdated Nullable`1
Risk String
Problem String
Solution String
Tracks Azure recommendations using latest Azure Advisor API - more info @ https://docs.microsoft.com/en-us/rest/api/advisor/
AzureElasticJobAgentExecutions
AzureElasticJobAgentExecution[]
JobName String
JobVersion Nullable`1
ProvisioningState String
CreateTime Nullable`1
StartTime Nullable`1
EndTime Nullable`1
DurationInSeconds Nullable`1
StepName String
Target String
LastMessage String
Tracks job execution of current Elastic Job Agent
AzureMonitorMetric
Double
Tracks Azure metrics using latest Azure Monitor API - more info @ https://docs.microsoft.com/en-us/rest/api/monitor/
DerivedMetric
Double
Allows for deriving new metrics from existing ones. Useful for combining existing metrics together or for multiplying metrics by a factor
LinkedMetric
Object
Allows for tracking of metrics from other resources. Useful when it is important to evaluate metrics from different resources side-by-side
ResourceStatus
String
Tracks overall status of the resource. This is an important metric as it is used to drive Uptime reports. Possible values: Ready, Down, Unknown and in some cases Stopped

Available Commands

Possible commands that can be executed on a given resource. Ultimate subscription is required.

Command Type Description
WebRequest Runs custom WebRequest to specified URL

Default Templates

CloudMonix provided default monitoring templates.

Pre-configured Metrics

Metric Name Metric Type Description
CanceledJobs DerivedMetric Tracks canceled execution jobs count
Executions AzureElasticJobAgentExecutions Tracks Execution information for last hour of specified Elastic Job Agent
FailedJobs DerivedMetric Tracks failed execution jobs count
RecommendedActions AzureAdvisorRecommendationMetric Tracks recommended actions for specified resource.
Status ResourceStatus Tracks the overall readiness status of the monitored resource. Possible values are: Ready, Down, Stopped and Unknown
SucceededJobs DerivedMetric Tracks succeeded execution jobs count

Pre-configured Alerts

Alert Name Expression Severity Description
Failed Jobs Detected FailedJobs > 0 Warning Raises when found any failed job execution
Resource Outage Status == "Down" Error Raises an alert when connectivity cannot be established, after specified number of retries on the Advanced tab for sustained period of time