Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cddot
Starting Member
37 Posts |
Posted - 2009-02-19 : 20:50:20
|
| SQLServer 2005.In the Plan/Modify window, there are two buttons next to the Subplan schedule.Click on the left button, there is an option to check/uncheck the Enabled option.The right button allows you to remove the schedule (to make it un-scheduled).I just want to stop the plan from running - do both buttons achieve the same thing? Or there is a not-obvious difference somewhere? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cddot
Starting Member
37 Posts |
Posted - 2009-02-19 : 21:42:51
|
| Ah, more options to achieve the same thing in SQL Server Agent...Ok, I'll go with your first suggestion - right-click Disable job in SQL Server Agent, thanks. |
 |
|
|
|
|
|