I would like to know if there is any way to get Agent jobs such as backups, Update Stats jobs to write to the error log on failure. I have written a monitoring program that looks in the errorlog and alerts on pertinent errors. I would like to be able to use this solution for agent job failures without having to set up database mail and operators in order to get my alerts. I am working with SQL Server 2000 and SQL Server 2005 and will have some 2008 instances soon.
Thanks for all the help.