September 27, 2007 at 2:44 pm
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?
September 28, 2007 at 11:12 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply