You can configure Operational Insights to send Data Ingestion and Replication alert notifications to users when application ingestion and replication jobs or database ingestion and replication jobs detect certain status changes, DDL changes, or delays in processing DML data. For example, you can alert an administrator when the job status changes to Failed or Running with Warning.
For you to configure alerts, your organization must have the OperationalInsightsAdvancedEdition license with the Job Alerts feature. Also, to create or modify alerts, you must have the one of the following roles:
•Admin role
•A custom role that has the Operator role along with the Read privilege for the User and Group assets for Administrator service.
These role requirements do not pertain to users who only read alerts.
From the Data Ingestion and Replication Alerts tab on the Alerts page, you can create, edit, or delete alert rules. To create an alert rule, click Create Alert. To edit or delete a listed alert rule, click the pencil or trash can icon at the right end of the rule row in the list.
You can configure an alert rule to send alerts when one or more of the following types of events occur:
•The status of an application ingestion and replication job or database ingestion and replication job changes to a status that you selected for alerting.
•A DDL schema change event occurs for incremental load or combined initial and incremental load jobs that have schema drift enabled.
•An incremental load or a combined initial and incremental load job has not been processing any DML data for a significant period of time.
Also specify the recipients of the alert notifications and whether the alert rule applies to the entire organization or to a selected ingestion task.
Operational Insights polls for application ingestion and replication and database ingestion and replication alerts every 5 minutes.
Configuring alerts for Data Ingestion and Replication jobs
You can configure alerts for application ingestion and replication jobs and database ingestion and replication jobs to notify users about the job status, DDL changes, and delays in CDC processing. Alerting is not supported for file ingestion and replication jobs and streaming ingestion and replication jobs.
1On the Alerts page, click the Data Ingestion and Replication Alerts tab.
2Click Create Alert.
3On the Create Alert Rule page, configure the alert details:
aIn the Alert Rule Name field, enter a name for the alert. Maximum length is 255 characters.
bIn the Alert Rule Description field, enter an optional description for the alert. Maximum length is 255 characters.
cIn the Ingestion Type field, select Application Ingestion and Replication Task or Database Ingestion and Replication Task or both options.
dIn the Rule Applies To field, configure the alert scope by selecting one of the following options:
▪ ·Entire Org. Apply the alert rule to all jobs in the organization.
▪ Task Asset. Apply the alert rule to the jobs associated with the ingestion task that you select.
4In the Alert Enabled field, enable or disable the alert rule. Disable the alert if you do not want alerts to start being sent right away. By default, the alert is enabled.
5 Configure alert conditions in one or more of the following ways:
- To alert based on a job status change, select each job status for which to send an alert. By default, only Failed is selected.
- To alert when a source schema change is detected, select DDL. This option applies to incremental load and combined initial and incremental load jobs for which schema drift options are enabled.
- To alert when an incremental load or a combined initial and incremental load job has not been processing any DML data for a significant period of time, select Source CDC Delay.
6In the Send Email To field, select one or more users or user groups to send email notifications for the configured alerts to.
You can select multiple users individually, one or more user groups, or any combination of individual users and user groups. To be available for selection, the users and user groups must have been previously defined in Administrator service.