February 12, 2009 at 11:51 pm
HI,
If I forcefully stop the job does it rollback or stops to that point ?
February 13, 2009 at 12:54 am
If you stop and cancel the job when it is in the middle of an operation, this operation will be rolled back. If the step already finished running some statements, then it depends on the way you wrote the step. If you wrote it as a transaction (e.g. you specified begin transaction in the code), then the whole transaction will be rolled back. If you didn’t then only one statement (the statement that was running when you cancelled the job) will be rolled back.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 13, 2009 at 12:58 am
Cool
Thankyou Verymuch.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply