If you select Daily, in the Recurs every box, enter how often the job schedule repeats in days. Under Frequency, on the Occurs list, specify the frequency of occurrence: Select or clear the Enabled check box to enable or disable the schedule.
Start automatically when SQL Server Agent starts On the Schedule type list, select the type of schedule: In the New Job Schedule dialog box, in the Name box, enter the job schedule's name. If you selected Single schedule for the entire plan or no schedule, under Schedule, click Change. below for each task in your maintenance plan. NOTE: If you select Separate schedules for each task, you will need to follow the steps in e. Select either Separate schedules for each task or Single schedule for the entire plan or no schedule to specify the recurring schedule of the maintenance plan. In the Run as list, specify the credential that Microsoft SQL Server Agent uses when executing the maintenance plan. In the Description box, briefly describe your maintenance plan. In the Name box, enter the name of the maintenance plan you are creating. On the SQL Server Maintenance Plan Wizard page, click Next. Right-click the Maintenance Plans folder and select Maintenance Plan Wizard. Use the Maintenance Plan WizardĮxpand the server where you want to create your management plan. Object Explorer only displays the Maintenance Plans node for users who are members of the sysadmin fixed server role.
To create or manage maintenance plans, you must be a member of the sysadmin fixed server role. You must enable Agent XPs Server Configuration Option. To guard against this elevation of privilege when running maintenance plans, data collection sets, and other Integration Services packages, configure SQL Server Agent jobs that run packages to use a proxy account with limited privileges or only add sysadmin members to the db_ssisadmin and dc_admin roles. This elevation of privilege can occur because these roles can modify Integration Services packages these packages can be executed by SQL Server using the sysadmin security context of SQL Server Agent. Members of the db_ssisadmin and dc_admin roles may be able to elevate their privileges to sysadmin. You must create and maintain the multiserver maintenance plans on the master server. To create a multiserver maintenance plan, you must configure a multiserver environment with one master server, and one or more target servers. This allows you to perform various database administration tasks, including backups, database integrity checks, or database statistics updates, at specified intervals. The Maintenance Plan Wizard creates a maintenance plan that Microsoft SQL Server Agent can run on a regular basis. This topic describes how to create a single or multiserver maintenance plan using the Maintenance Plan Wizard in SQL Server. Applies to: SQL Server (all supported versions)
0 kommentar(er)
