There is already post for this which sends email on failure:
This one goes bit further and checks if aggregation has failed 3 consecutive time, also for workday we are ignoring failures if it is Saturday as it is maintenance day for workday tenant.
AggregationFailureTrigger20231116 (1).json (8.3 KB)
Send emails events inside this can be ignored and tuned as per need.