3

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!

Community
  • 1
  • 1
slayernoah
  • 4,382
  • 11
  • 42
  • 73
  • ***SQL*** is just the *Structured Query Language* - a language used by many database systems, but not a a database product... many things are vendor-specific - so we really need to know what **database system** (and which version) you're using (please update tags accordingly).... – marc_s Jul 17 '13 at 18:37

1 Answers1

8

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.

Anon
  • 10,660
  • 1
  • 29
  • 31