I have a set of stored procedures and flowgraphs which are running and loading data on an intraday basis. If there is an error with the processes I would like to alert someone that something has gone wrong and that they need to investigate.
What is the recommended way to do this?