sql-server-2008sql-agent-job

If I disable the Job which is running it will stop the Job?


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.


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?