INFO-统计已调度任务配置告警信息

适用模块

离线开发

具体说明

查询已调度任务配置的告警信息

使用示例

select
  flow.cluster,
  flow.product,
  flow.flow_name,
  flow.owner,
  flow.baseline_name,
  alert.rule_type,
  BIN(alert.alert_channel)
from
  eto_az_flow flow
  join (
    select
      az.flow_name,
      az.product,
      rule.rule_type,
      rule.alert_channel
    from
      alert_rule rule
      join alert_azkaban az on az.id = rule.biz_id
    where
      rule.is_delete = 0
      and rule.biz_type = 1
  ) alert on flow.product = alert.product
  and flow.flow_id = alert.flow_name;

注：最后一列为报警通道类型，需转为二进制进行比对，例如100为邮箱报警，110为邮箱+短信

作者：林帅