Notify rules authors automatically when pipeline goes red

Sometimes downstream / main branch jobs go red on their daily crons, it would be useful if an issue was automatically filed in this case so it could be triaged

// @Yannic

No file or test is identified; start by locating the daily cron pipeline jobs and the entry point responsible for notifications or issue creation. Done means a red downstream or main-branch cron run automatically files a triage issue for the relevant rules authors, with the behavior covered by an appropriate test.

Written by the indexing model from the issue text.