What is the best way to distribute scheduler job output through email
I need to send report output for night-time scheduler jobs to various employees. I'm new to Orchestrator. I wrote an orchestration that finds the list of jobs that ran for each user, but I don't see a way to send multiple report links based on how many jobs are found. So I decided to send one notification per job, but I can't find documentation on how to call an orchestration from a table trigger (on F986110 for example). Is the best way using BIP?
Any advice is appreciated.