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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-27 : 09:42:31
|
| xiaosha writes "Hi all. I'm using SQL 2000. I hve created a job that is supposed to run every day at 12pm. but i realised each time after the job is run, the sql agent stopped by itself, and i hve to manually restart the agent and re-run the job myself. why is this so? i hve set the sql agent to run automatically under the Services Console in Administrative Tools (Windows 2000). appreciate all your help. rgds" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-27 : 13:04:14
|
| Check your event logs, as well as your sqlserver and sqlagent errorlogs. You may find a clue in there.-Chad |
 |
|
|
|
|
|
SQL Server Agent Stop by itself