Friday, February 24, 2012

Changing job while running....PLEASE HELP!

I have a job that contains 2 steps. Right now the job is setup to quit with
success for both steps, and the job is currently running. I would like to
have to job go on to step 2 after step 1 is complete. Is it possible to
change the job to go to next step after step 1 is complete, or is it too late
once the job has already been started?
Thanks!!!!
The actual work itself only lasts as long as it takes to do the work. If I
schedule a job to run every hour it only runs once an hour, not all the
time. So yes you can change it and the next time it runs it will be as you
changed it.
Andrew J. Kelly SQL MVP
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:A4638A8F-8520-4E2B-8BF6-519F16509F2B@.microsoft.com...
>I have a job that contains 2 steps. Right now the job is setup to quit
>with
> success for both steps, and the job is currently running. I would like to
> have to job go on to step 2 after step 1 is complete. Is it possible to
> change the job to go to next step after step 1 is complete, or is it too
> late
> once the job has already been started?
> Thanks!!!!
|||Once the job is running you cannot change it. You can, however, alter the
job to just run the second step and manually run it once the first step is
done if you're concern is to run the second step even if the first step fails.
burt_king@.yahoo.com
"Andy" wrote:

> I have a job that contains 2 steps. Right now the job is setup to quit with
> success for both steps, and the job is currently running. I would like to
> have to job go on to step 2 after step 1 is complete. Is it possible to
> change the job to go to next step after step 1 is complete, or is it too late
> once the job has already been started?
> Thanks!!!!

No comments:

Post a Comment