job running

• Sailor

  SSCertifiable

  Points: 5246

  More actions

  October 28, 2004 at 2:54 pm

  #85702

  I have a sql2k job running now and I saw one step further down that I had to do an update on.  Will those changes take effect when that step runs or only when the job runs next time?

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  October 29, 2004 at 12:30 pm

  #528434

  If you try to make a change to the job itsself it won't let you because the job is running. If you modify say a stored procedure that the job calls I do belive it will run with that change it looks for the next step out of the msdb database in the sysjobsteps table as it gets to them.

  Wes