Our SQL 2000 machine had SP1 installed recently and since then the SQL Agent stops with no warning and with no apparent pattern except mostly on the hour or half hour. e.g. 7:00 AM, 12:30 PM, 9:30 AM etc
None of the tasks run by the agent have been executed at all the times that the Agent has stopped.
The windows event viewer has an error logged like:
The SQLServerAgent service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 180000 milliseconds: Restart the service.
Our server has 4GB of RAM and the /PAE switch and AWE enabled in SQL configuration. THe machine is using Win2K AS and SQL 2000 EE.
Note: The problem is not the same as the problem with multiple emails in an operator causing SQL agent to stop.
Has anyone else experienced something like this? Without giving anyone pre-conceived ideas, I would like to know if anyone can describe something similar and what symptoms you may have seen.