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