At a client of mine we recently found out that some of the Scheduled tasks on some Windows 2008 Servers failed without us noticing, because they wouldn't report to the event log which is monitored.
The event log entries that the Task Scheduler write are useless because even though they have the exit code of the task, they are of the informational type regardless of the exit code.
So I wrote a small tool that monitors the "Last Run Result" of the tasks on a local machine and sends an email if the result was unexpected.
To learn more and download this tool, go to the Motash page