Introduction
Elastic Job agents run and manage scheduled T-SQL jobs across one or many Azure SQL databases. A SQL Job Agent is provisioned on an Azure SQL server and is discovered as a dependency of its parent SQL Server.
Use the OpsRamp Azure Public Cloud integration to discover Azure SQL Job Agents and collect metrics.
Setup
To set up the Azure integration and discover Azure SQL Job Agent resources:
- Create an Azure integration if one is not already available in your installed integrations. See Install Azure Integration.
- Create a discovery profile. See Create Discovery Profile.
- On the Edit Discovery Profile page, select SQL Job Agents under Filter Criteria.
- Save the discovery profile to make it available in the discovery profile list.
- Run a scan to discover resources, independently of the predefined schedule.
- After the scan completes, view Azure SQL Job Agent resources under Infrastructure > Resources > Microsoft Azure. The SQL Job Agent appears as a dependency of its parent Azure SQL Server.
Supported Metrics
| OpsRamp Metric Name | Azure Metric Name | Display Name | Unit | Aggregation | Description |
|---|---|---|---|---|---|
| azure_sql_servers_jobagents_elastic_jobs_failed | elastic_jobs_failed | Elastic Jobs Executions Failed | Count | Total | Number of job executions that failed on target. |
| azure_sql_servers_jobagents_elastic_jobs_successful | elastic_jobs_successful | Elastic Jobs Executions Successful | Count | Total | Number of job executions that succeeded on target. |
| azure_sql_servers_jobagents_elastic_jobs_timeout | elastic_jobs_timeout | Elastic Jobs Executions Timed Out | Count | Total | Number of job executions that timed out. |
Event Support
OpsRamp supports Azure events for Azure SQL Job Agents. Configure Azure Events in the Azure integration discovery profile. See Process Azure Events for instructions.