Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tigger
Yak Posting Veteran
85 Posts |
 Posted - 2002-09-01 : 19:32:52
|
For 3 of the last 4 days I have come in in the morning and SQL Agent has stopped overnight. I can get it to start again with no problemsBut no-one seems to know why.The system log just says "The SQLSERVERAGENT service terminated unexpectedly." The only thing in the SQL agent log is from when I have restarted it.Any one have any ideas on what could be causing this, where to look?Also, if SQL agent stops after starting a job to execute a package, will the job still be running ... our month end processing was running when SQL agent died this morning  |
|
|
Tigger
Yak Posting Veteran
85 Posts |
Posted - 2002-09-03 : 16:56:54
|
SQL Agent was fine yesterday morning but it had stopped again this morning, and yet again for no apparent reason - AAAaaarrgghh !!!  |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-03 : 17:26:11
|
| Check your errorlog.Also, check the archived sqlagent logs (.1-.n)They may give you an idea.-Chad |
|
|
|
Tigger
Yak Posting Veteran
85 Posts |
Posted - 2002-09-03 : 19:40:29
|
| I've checked the sqlagent error log and have just checked the archived sqlagent logs.sqlagent error log had nothing in it since I restarted it last time.last thing in the archived logs was database backup which finished at5:38 this morning. sqlagent died at 7:33. |
|
|
|
|
|
|
SQL Server Agent stopped