-
Notifications
You must be signed in to change notification settings - Fork 0
/
scheduler_monitoring.py
52 lines (39 loc) · 1.47 KB
/
scheduler_monitoring.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
from datetime import datetime, timedelta
from os import environ
from airflow import DAG
from airflow.hooks import PostgresHook
from airflow.operators.slack_operator import SlackAPIPostOperator
default_args = {
'owner': 'airflow',
'depends_on_past': False,
'start_date': datetime.today(),
'email': ['airflow@airflow.com'],
'email_on_failure': False,
'email_on_retry': False,
'retry_delay': timedelta(minutes=5),
}
dag = DAG("scheduler_monitoring", default_args=default_args, schedule_interval='05 * * * *')
slack_token = environ.get('SLACK_TOKEN')
def get_event_status(**kwargs):
cur = PostgresHook('airflow_db').get_cursor()
sql = """SELECT
task_id,
dag_id,
to_Char(dttm, 'HH24:MI:SS')
FROM public.log
WHERE owner = 'airflow'
AND event = 'failed'
AND dttm >= current_date - interval '5 minutes'"""
cur.execute(sql)
result = cur.fetchall()
return result
result = get_event_status()
if result:
message = ''
for strings in result:
task_name, dag_name, time = strings
msg = "Task '{}' in DAG '{}' was failed at {} today.".format(task_name, dag_name, time)
message = message + '\n' + msg
slack_monitoring = SlackAPIPostOperator(dag=dag, task_id='slack_monitoring',
token=slack_token,
channel="#airflow", text=message)