Search code examples
sqlsql-servermaintenance-plan

SQL Maintenance Plan - End Task


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!


Solution

  • 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.