Cloudera Docs

Triggering email alerts for your workload views

You can trigger daily email alerts for your Workload Views, based on your defined service-level agreement (SLA) performance threshold and/or your workload job or query failures. When a Workload View’s SLA reaches or exceeds the defined threshold, or the workload jobs or queries reach or exceed the failure percentage, an email alert is triggered for you to take action upon its receipt.

Steps on how to enable email alerts for your Workload Views.
  1. Verify that you are logged in to the Cloudera Observability On-Premises web UI.
    1. In the URL field of a supported web browser, enter the Cloudera Observability On-Premises URL that you were given by your system administrator and press Enter.
    2. When the Cloudera Observability On-Premises Log in page opens, enter your Cloudera Observability On-Premises user name and password access credentials.
    3. Click Log in.
      The Cloudera Observability On-Premises web user interface landing page opens, which by default displays the Analytics Environments page that lists your Workload cluster environments.
    4. From the Environment Name column in the Environment's table, select the environment required for analysis.

      The Environments navigation panel opens, which hierarchically lists the environment's cluster, engines, and if applicable the Hive Metastore category.

  2. Depending on the environment selected, verify that the Cluster Summary page is displayed for the environment's cluster required as a workload view.
    To display the Cluster Summary page for a Data Hub, Virtual Cluster, and Virtual Warehouse environment type, do one of the following:
    • From the Environment panel, expand the service's category and depending on the service, locate and select the Data Hub's cluster, Virtual Cluster, or Virtual Warehouse that is required for analysis.
    • In the Data Services table, drill-down through the service links to locate and select the Data Hub's cluster, Virtual Cluster, or Virtual Warehouse that is required for analysis.
  3. Select the Workloads tab.
  4. Do one of the following:
    1. If no other Workload Views exist, in the Workloads page, click Manual.
    2. If other Workload Views exist, from the Define New list, select Manual Definition.

    The Criteria Definition widget opens, where you define the criteria for the Workload View that will alert you when the SLA or specific workload jobs or queries reach or exceed the defined threshold or failure percentage.

  5. In the Name field, enter a unique name that is easily identifiable.
  6. From the Engine list, select the engine in which the job or query is run. For example, Impala.
  7. Specify the Criteria condition by doing the following:
    1. From the Criteria list, select a criteria filter item from the available options.
      You can set multiple conditions for the selected filter item. For example,
      • If you selected User, you can include ANY or NONE of the available users in the Select user list.
      • If you selected Pool, you can include ANY or NONE of the available pools in the Select pool list.
      • If you selected Query Start Time, you can include IN RANGE or NOT IN RANGE of your selected time period.
  8. In the SLA field, enter the threshold unit for the completion of a job or query, using the following abbreviations as the time units:
    • h = hours
    • m = minutes
    • s = seconds
    • ms = milliseconds

    The time units must be in chronological order, where hours come before minutes, minutes come before seconds, and seconds come before milliseconds, and cannot have a space between the threshold number value and the time unit. For example, 2h 20m 3s. The threshold time value can also be entered as a whole time unit, where instead of entering 1h 10m you can enter 70m.

  9. In the Warning Threshold field, enter a percentage value that when exceeded by either the number of jobs or queries failing the SLA value or failing execution completion, triggers a Warning status and if applicable triggers an email alert notification.
  10. Optional: For users with the Cloudera Observability On-Premises Premium license tier, you can enable the email alert notification when the threshold or the number of failed jobs or queries is exceeded.
    1. On the Workloads page, select the Workload View and from its Actions list, select Manage Email Alerts.
    2. On the Manage Email Alerts window, in the Alert Email field, enter the email address to which alert notification must be enabled, and press Enter or click the plus icon.
      The specified email address is displayed in the Current Alert Emails list. You can enter multiple email addresses. When enabled, a maximum of one email for each calendar day is sent to the specified email address notifying them of the exceeded threshold.
    3. Click Save to enable email alerts.
  11. Optional: To display a summary of the jobs or queries matching your criteria, click Preview. The date range, the number of jobs or queries that match the criteria, and the number of jobs or queries that missed the SLA condition or failed completion are displayed.
  12. Click Save.
    The Workloads page opens and your workload view appears in the Workload column.
  13. Optional: To view more information about the workloads using the view's formula, open its Summary page by clicking the name of the Workload View in the Workload column, which displays the view's details as chart widgets that you can use to further analyze the results.
  14. Optional: To delete an existing Workload View, do the following:
    1. In the Workloads page, locate and select the Workload View that requires deletion.
    2. From the Actions list, select Delete.
    3. In the confirmation message, click OK to confirm. The view is permanently removed.
  15. Optional: To create a new view do the following:
    1. Verify that the Cluster Summary page is displayed for the environment's cluster required as a workload view.
    2. Select the Workloads tab.
    3. From the Define New menu in the Workloads page, select one of the following:
      • To create a new manual view, select Manual Definition, in the Criteria Definition widget define a set of criteria for the view, and then click Save.
      • To automatically generate a new view, select Auto-generate Definition.

      The Workloads page reopens and your workload view appears in the Workload column.

  16. Workload Views cannot be edited directly. If you require changes to an existing Workload View do the following:
    1. In the Workloads page, Locate the Workload View that requires changes.
    2. From its Action list, select Clone.
    3. In the Criteria Definition widget make the changes you require, and then click Save.
      The Workloads page reopens and your workload view appears in the Workload column.
    4. Locate the Workload View that required changes and from its Action list, select Delete and then in the Confirm message, confirm its deletion by clicking OK.