Modifying running job?

  • 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.


    Live to Throw
    Throw to Live
    Will Summers

  • 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.



    Pradeep Singh

  • 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.


    Live to Throw
    Throw to Live
    Will Summers

  • 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.:-)



    Pradeep Singh

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply