Investigate notifications to a group when nightly job fails

[jkarpen]

Email from Andrew came in asking about the ability to send a notification to a group of dbt devs when the nightly job fails. CARB is using dbt core instead of cloud so they are relying on GitHub actions. Currently only the person who submitted the last PR is receiving the notification.

The goal for this issue is to investigate whether and how this is possible (notifying a group when the nightly job fails).

Relevant Doc: https://docs.github.com/en/account-and-profile/managing-subscriptions-and-notifications-on-github/setting-up-notifications/about-notifications