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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Maintenance Plans

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

Posted - 2009-02-19 : 21:31:47
Just disable or delete the job associated with the maintenance plan in SQL Server Agent.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -