Microsoft Azure SQL Elastic Job Agent is the resource for creating, running, and managing jobs. It reads the data for the jobs in the database and uses it to execute them against the target databases.
This step-by-step guide explains how to setup and monitor Azure SQL Elastic Job Agent using CloudMonix.
In this article
1. Monitoring setup
2. Collect, understand and use your data
3. Setup verification and troubleshooting
This article explains how to add resources to CloudMonix via the Setup Wizard.
b. Tweak settings in the Definition tab (optional):
Definition tab for an existing resource can be accessed by clicking the resource's monitoring settings in the performance dashboard:
Definition tab provides optional settings for the resource name, Azure resource group, management token, Azure resource name, Azure SQL server, configuration template and categories:
c. Manual setup (optional instead of the Setup Wizard route):
Click the Add New button in the top right corner of your dashboard:
Fill in required information in the Definition tab as described in the previous step.
d. Advanced configuration:
Advanced configuration tab provides additional monitoring settings, which are already set as default for most use-cases.
Collect, understand and use your data
Diagnostic data points retrieved from the monitored resource are referred to as metrics . CloudMonix provides default templates for the metrics recommended for common configurations. Metrics can be further added, removed or customized in the Metrics tab of the Azure SQL Elastic Job Agent resource configuration dialog:
CloudMonix features a sophisticated alert engine that allows alerts to be published for very particular conditions pre-defined by a template configuration or custom based on any of the available metrics. Alerts can be further added, removed or customized in the Alerts tab of the Azure SQL Elastic Job Agent resource configuration dialog:
Actions are automation features that can be configured to fire based on specific conditions or schedule. Actions can be added and configured in the Actions tab of the Azure SQL Elastic Job Agent resource configuration dialog:
Setup verification and troubleshooting
a. Setup verification:
Successful resource setup can be verified by clicking Test button in the resource configuration dialog and visiting the Test Results tab:
b. Troubleshooting monitoring issues:
CloudMonix provides deep insights into resource monitoring issues via the Status Dashboard screen. The screen allows to overview resources that have raised alerts and troubleshoot them by diving into the monitoring logs.
Read the full article on how to use Status Dashboard to diagnose resource monitoring issues.