steps to be skipped in job

• scottichrosaviakosmos

  SSCommitted

  Points: 1889

  More actions

  October 11, 2011 at 2:27 am

  #258660

  I have a job with almost 10 steps in it.

  I want to disable the steps as per my wish programatically.

  ex: if 1 have to disable step 3 then i will skip step 3 and after 2nd step 4th should execute. but problem is that, may be step 4 is also disabled earlier. So if step 3 is skipped then it should go to a step which is active.

  I know the procedure sp_update_job AND table sysjosteps but I am not sure to work on it.

  I dont want to use user interface. I would like to create a script for this.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 11, 2011 at 6:06 am

  #1392791

  Duplicate post.

  Replies here please : http://www.sqlservercentral.com/Forums/FindPost1188266.aspx

  -- Gianluca Sartori