Users will be notified of an exception by a report sent by a schedule.
The schedule can be any standard View or Report type. (See topics on Report Schedule Creation.)
An “Exception” report could be created showing yesterday’s sales figures, or simply a text box saying “Error found in Nightly Jobs”.
If the schedule should only be executed when the exception occurs, then set it up to run “Once” at some date far in the future. That way it will never run unless called by the Exception Dataset Script.