Maintenance Plan Wizard (Select Plan Properties Page)

Use the Select Plan Properties Task page to determine the security context of the task, and the schedule for when the task runs.

  • Proxy account
    Specify the credential that Microsoft SQL Server Agent uses when executing the maintenance plan.

    Important

    Members of the db_ssisadmin role and the dc_admin role may be able to elevate their privileges to sysadmin. This elevation of privilege can occur because these roles can modify Integration Services packages and Integration Services packages can be executed by SQL Server using the sysadmin security context of SQL Server Agent. 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.

  • Schedule
    Describes when the maintenance plan will execute. Click Change to modify the schedule.