I haven't searched google or anything to find a solution but has anyone else found that their SQL Server Agents just randomly stop running? I've had this problem with a couple of my SQL Servers off an on for the last two years.
I have a large number of scheduled jobs that run that massages data to feed into other software systems on a daily basis. Every now and then some of the sql server agents will just stop running and I have to manually go in and start them. I can't seem to reproduce the problem and it is quite annoying to have to go in everyday and make sure that all of my jobs completed.
I know sql server has an e-mail notification feature, but I have never played with it. Perhaps its time to finally upgrade all the sql installations at work to sql 2005, perhaps this problem is fixed in the newer version of sql.