O'Reilly logo

Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Task Scheduling

Starting with Chapter 5, we begin a run of eleven chapters that explain the ins and outs of each of the eleven maintenance tasks that you can define and schedule as part of a SQL Server Maintenance Plan.

The scheduling of a task within a Maintenance Plan, created using the Wizard or Designer, is a step that is a little more complex than it may first appear, and is common to the configuration of every task that we'll discuss in subsequent chapters.

This chapter will therefore provide a broad overview of the essential elements of task scheduling, and the general issues that will determine when, and how often, maintenance tasks should run. This will allow us, in the subsequent chapters, to focus on scheduling advice specific ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required