July 29, 2009 at 6:47 am
I have a long-running job that I need to tweak. The problem is that the job take 22hrs to run.
What happens if I make a modification to a job that is currently running? Will the job fail?
Also, has anyone ever modified a running DOS batch file? Does it stop the process?
I basically just don't want to have to wait till 9pm tonight to make these modifications.
Thanks in advance for any responses to this post.
July 29, 2009 at 6:51 am
Will Summers (7/29/2009)
Also, has anyone ever modified a running DOS batch file? Does it stop the process?
No this doesnt break the job. The entire file is loaded into memory and then run so if u modify the source file, the job wont break.
I guess u're talking abt DOS based scheduled job and not sql server jobs.
July 29, 2009 at 7:02 am
I'm talking about both really.
I have a SQL Server Agent job that does some things, then runs a DOS batch job.
I want to make sure that if I modify both, then neither will break.
I assumed that it just loaded the job into memory and then ran, but I wanted to be sure.
July 29, 2009 at 7:11 am
not sure on this, but i think once a particular step is running, modifying it wont break. however, if the step has not run yet, it may process as per changed instructions...
May be u should wait for others' comments.:-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply