2012年2月24日星期五

Disabling a Step While a Job is Running

Hi,
Kind of a weird question. If I have a SQL job that runs for a long
time and while it is running I realize I want to skip one of the steps
which is still to come, can I update the job while it's running to
make it's On Success action either be, Stop the Job Reporting Success
or Go To Step X? Or does the job essentially get "loaded" when it
starts and no changes will take effect until the next run?
Thanks,
BillMy gut says no, but you could test it easilly by setting job steps with
'WAITFOR' .
"zinck74" <bkelly3@.gmail.com> wrote in message
news:1190238399.358816.128400@.k35g2000prh.googlegroups.com...
> Hi,
> Kind of a weird question. If I have a SQL job that runs for a long
> time and while it is running I realize I want to skip one of the steps
> which is still to come, can I update the job while it's running to
> make it's On Success action either be, Stop the Job Reporting Success
> or Go To Step X? Or does the job essentially get "loaded" when it
> starts and no changes will take effect until the next run?
> Thanks,
> Bill
>

没有评论:

发表评论