If I disable the Job which is running it will stop the Job?
sql-server-2008
Solution
if you disable a job while it is running, it WILL continue the execution that was already started. Is that what you want to know?
Problem
In SQL SERVER 2008, If I disable the Job which is running it will stop the Job ? I have tested the iteM two weeks ago, and the result is it will rollback the running job according the last reslut of Disable/Enable. I have double tested the item, but the result is opposite. It will not stop the running job when the job has been disabled. Thanks.