608
Part V: Enterprise Data Management
Sometimes you may not want to use the Properties window. For example, you might be
working with a new task. In this case, you can bypass the Properties window by double-
clicking the task. A task-specifi c window for a backup task appears, as shown in Figure
22-4. Unlike the Properties window, this dialog box displays the task properties in context.
In addition, it grays out task elements until you defi ne the correct functionality. For exam-
ple, when you choose to back up specifi c databases, the dialog box won’t let you perform
any other confi guration task until you choose one or more databases for the backup.FIGURE 22-4
In addition to the Properties window, you can use the task-related dialog box for
confi guration.It’s interesting to click View T-SQL when you fi nish confi guring the task. The resulting
window like the one shown in Figure 22-5, displays the T-SQL that the task uses. The
Transact-SQL (Task Generated) window won’t let you edit the command, but seeing how the
Maintenance Plan Wizard generates the code can prove helpful when you need to create
T-SQL commands of your own.c22.indd 608c22.indd 608 7/31/2012 9:24:33 AM7/31/2012 9:24:33 AM
http://www.it-ebooks.info