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.