Add a cleanup task to a maintenance plan

- [Instructor] In this section,…we're going to look at modifying the maintenance plan…that we created in the previous section.…So, I'll go to that maintenance plan,…right click on it, and go to Modify.…This will pull up a little bit of a different interface.…When we created the maintenance plan, we used a wizard,…but when we modify it, we don't use a wizard,…so the interface is a little different.…We're going to use this main design window,…and also the toolbox.…If the toolbox didn't appear for you automatically,…you can get it off the View menu, go to Toolbox,…and here in the toolbox, we see a list of all the tasks…that can be performed in a maintenance plan.…

The one I'm interested in is a cleanup task.…This is going to go in and delete some of the old files,…so I'm going to drag Maintenance Cleanup Task…onto the main design surface.…I'd like this cleanup task to run after…the full database backup, so I'll click on the box…that represents the Back Up Database Full task,…then I'll take the green arrow that comes out of the bottom…

Resume Transcript Auto-Scroll

Author

Released

11/16/2016

SQL Server supports mission-critical applications and big data solutions—without having to buy expensive add-ons or high-end appliances. Learn the essentials of Microsoft's latest release, SQL Server 2016. Use tools like SQL Management Studio and the Configuration Monitor to deploy and manage databases both on premises and in the cloud. Learn how to create new databases, build tables, define relationships, write queries, and use stored procedures and built-in functions. Instructor Martin Guidry—a SQL Server veteran—also shows how to manipulate XML and JSON data, and perform crucial database administration tasks, such as backups and restores, security enhancements, and performance monitoring. Plus, find out how to extend SQL Server by integrating it with cloud services like Microsoft Azure.