Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Using SQLServer 2008.

Just curious as to what happens when an administrator shuts down a server machine when an SQL Server Agent job happens to be running. In our case, the jobs could take several minutes to run (i.e. transaction log shipping COPY and RESTORE jobs).

What will happen to the running jobs - will they be allowed to complete before the machine is shutdown, or is there some upper waiting period before the jobs are killed etc (if killed, what determines the waiting period etc).

Is it safer to stop the jobs manually before shutting down the machine ?

Thanks.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

Expect the running jobs to stop when the SQL Agent service stops. I use log shipping and routinely shut down my LSCopy & LSRetore jobs just so I know the state of log shipping prior to server shutdown.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.