Part VI Enterprise Data ManagementMột số thủ thuật như kế hoạch bảo trì Wizard tạo việc làm sau hậu trường khi bạn sử dụng chúng. Bất kỳ hình thức nhân rộng cũng tạo ra công ăn việc làm sau hậu trường. Cũng như với các cảnh báo, tạo ra một công việc mới bằng cách sử dụng hộp thoại New Job. FIGURE 43-7 Set the conditions that you consider equivalent to CPU idle time. Some wizards such as Maintenance Plan Wizard create jobs behind the scenes when you use them. Any form of replication also creates jobs behind the scenes. As with. | Part VI Enterprise Data Management 1022 FIGURE 43-7 Set the conditions that you consider equivalent to CPU idle time. Some wizards such as Maintenance Plan Wizard create jobs behind the scenes when you use them. Any form of replication also creates jobs behind the scenes. As with alerts create a new job using the New Job dialog. Creating a job involves five distinct steps 1. Create a job definition. 2. Set each step to execute. 3. Set the next action for each step. 4. Configure a job schedule. 5. Handle completion- success- and failure-notification messages. The following sections walk through each of these steps. The first section that follows discusses the optional step of creating a job category. Automating Database Maintenance with SQL Server Agent 43 Creating a job category As you will see in the next section when defining a job you can assign a category to it. This enables you to group similar jobs together. Here are the steps you can use to manage job categories 1. Start SQL Server Management Studio. 2. Right-click the SQL Server Agent Jobs folder and choose Manage Job Categories from the context menu. This brings up the Manage Job Categories dialog shown in Figure 43-8. FIGURE 43-8 The Manage Job Categories dialog enables you to maintain the job categories used when you define a new job. 3. Create a new job category by clicking Add. This brings up the New Category properties dialog. 4. Type a descriptive name for the category in the Name field. 5. Add jobs to this category by clicking the Show All Jobs check box and selecting the corresponding check box in the Select column of the job list. Jobs that don t have a category assigned automatically appear in the list. Selecting Show All Jobs will also reveal jobs that already have a category assigned. 1023 Part VI Enterprise Data Management 6. The Manage Job Categories dialog is also the place to remove existing job categories. Highlight the job category to be deleted .
