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 |
|
malawneh
Starting Member
24 Posts |
 Posted - 2007-01-25 : 15:02:55
|
| SQL Server goes doen unexpectedly due to a job. In the job there are 6 steps. In the job history for the job. Step1 is mysteriously skipped and the logging begins with Step 2 through 6 on the history for the job.I have verified that all steps are set to run and are in fact in the correct sequence. The question is...Is it possible for the SQL SERVER AGENT to still be running if SQL SERVER terminates unexpectedly? I know when turning off SQLSERVER Service it requires the Shut down of the Agent. But is this still required when the SQL SERVER Is terminated Unexpectedly??Michael Alawneh, DBA |
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2007-01-26 : 12:58:32
|
| Hello, Michael!First of all, could you post what is executed in each step?About the Agent Service, The SQL SErver Agent will still running even if the SQL SErver Service terminated unexpectedly. I've done tests about it and the SQL Server Service started again, it because the SQL SErver Agent.So, if the SQL Server Service terminated unexpectedly and the SQL Agent SErvice is still running, the Agent will send a RPC for the SQL Server Service, starting it again without any action.I am waiting the steps of the JobJuliano Horta |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-29 : 12:43:18
|
| sql server is required to be running for the agent to be of any use. this is becuase the agent jobs are stored in the MSDB database.so, technically, maybe the agent can still be a running process if sql server dies. However, it can't really do anything since MSDB is gone.-ec |
|
|
|
|
|
|
SQL Server Goes Down Unexpectly.