Scheduled Processes: Warning and Errored notifications
We are completing a health check on Scheduled Processes on behalf of the customer and have completed some detailed analysis using the Scheduled Processes User Interface.
We now want to check if the scheduled process has been sent up to send a Warning or an Error to recipients, however it does not appear possible to check this within the User Interface, even when checking the Parent ID and the original schedule.
Does anyone have any custom SQL that we can run that would show us this? I have included a screen shot attached for reference of what we need.