SQL Maintenance Plan - End Task

slayernoah picture slayernoah · Jul 17, 2013 · Viewed 9.3k times · Source

Is there any way to stop a maintenance plan after it has been triggered? I have one that is running in Production and need to stop is ASAP.

Appreciate any suggestions/ideas. Thanks!

Answer

Anon picture Anon · Jul 17, 2013

Assuming SSIS w/ SQL Server, "SQL Server Agent" -> "Job Activity Monitor". Right-click the job that you don't want running and select "Stop Job"

This could be worse than letting the job run. Be warned.