title: Need script to change sql server job step properties
body: <p>currently im using Sql server 2008 r2 (will soon be upgrading to 2014). I need some help in changing job step properties using script.</p>
  
  <p>I have around 20 jobs with each job having 4 steps.</p>
  
  <p><img src="https://i.stack.imgur.com/bJBLa.png" alt="enter image description here"></p>
  
  <p>I'm trying to change the below highlighted option using sql server script. Because manually changing all these options is a difficult task.</p>
  
  <p><img src="https://i.stack.imgur.com/7MS0s.png" alt="enter image description here"></p>
  
  <p>Please help me in writing script to remove the output log path, uncheck append to log, check log to table and check append log to table options.</p>