Managing Maintenance Plans Without the Wizard
You can create or modify maintenance plans in SQL Server 2012 without using the Maintenance Plan Wizard. To create a new maintenance plan without the wizard, you right-click the Maintenance Plan node in the Object Explorer and select New Maintenance Plan. You are prompted for a maintenance plan name and then taken to the Design tab for the maintenance plan. The Design tab consists of a properties section at the top of the screen and a plan designer surface that is empty for a new maintenance plan.
Existing maintenance plans are displayed in the Design tab when you right-click the plan and select Modify. Figure 29.13 shows the Design tab for a maintenance plan that was created with the Maintenance ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
