March 19, 2009 at 7:03 am
Can i add a job step in a job which is already executing. I mean is it possible to add a job step while the job is executing.
thanks
March 19, 2009 at 7:26 am
I think you'll end up with locking problems if you do that. I've tried similar things on a running job, and I got error messages.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 19, 2009 at 7:34 am
what is it locking??
March 19, 2009 at 7:36 am
It means the job is protected from alteration while it's running. Means you'll get an error message if you try to modify it "in flight".
Basically, it's meant to protect you from the database equivalent of what would happen if you tried to change a tire on a moving vehicle. (You'd get run over, if you're wondering.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply