title: What happens if SQL Server job steps are modified during execution
body: <p>We use SQL Server 2008 and have a job that typically runs 18+ hours and has many steps. I have searched and can't seem to find an answer regarding what happens when you modify a job during execution. Below is a summary of the changes I made to the job during execution today:</p>
  
  <p>1) I inserted a new step at the 'step 2' position. The job was already at step 15 so presumably this step will not fire until the next time the job runs.</p>
  
  <p>2) I deleted the last step (step #30).</p>
  
  <p>3) I modified step 29 from 'go to the next step' to 'Quit reporting success'.</p>
  
  <p>Since step #15 was in progress when I made the change today, will the changes I made to the final steps take effect when the job gets to that point today or will they only be effective the next time it runs? </p>
  
  <p>Also, will the fact that I inserted a new step in the #2 position affect the step order adversely for the current run?</p>