sp_add_jobstep @flags parameter

• Mike Good

  SSCertifiable

  Points: 7415

  More actions

  September 27, 2007 at 2:44 pm

  #153863

  I'm trying to script process for adding some jobs, and I wanted the result to be just like an existing, working job. So for my starting point I used SSMS, highlighted the job & clicked "script job as...". The resulting script showed @flags = 34. Per BOL, that is not a possible option, and I can't determine what it means. I've checked other jobs and have seen @flags = 32, and other values as well that lead me to believe

  a) flags can be a combination of these values (e.g. 24 = 16 + 8) not "one of" them; and

  b) 32 is a possible value, but I don't know what it means.

  In addition to BOL I've scoured online resources, but all are consistent, say: "flags is an int, and can be one of these values: 0, 2, 4, 8, 16".

  Has anyone already looked into this?

• Mike Good

  SSCertifiable

  Points: 7415

  More actions

  September 28, 2007 at 11:12 am

  #737212

  Here's what I've figured out so far:

  BOL wording "can be one of these values" is wrong. @flags values are definitely meant to be combined.

  Undocumented value 32 = "include step in output history"

  32 is just like (redundant to) the documented value of 4, but 4 is apparently only for TSQL steps.