MaintenancePlan 类

定义

命名空间:

Microsoft.SqlServer.Management.DatabaseMaintenance

程序集:

Microsoft.SqlServer.MaintenancePlanTasks.dll

public ref class MaintenancePlan

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Security", "CA2112:SecuredTypesShouldNotExposeFields")]
public class MaintenancePlan

[<System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Security", "CA2112:SecuredTypesShouldNotExposeFields")>]
type MaintenancePlan = class

Public Class MaintenancePlan

继承

Object

MaintenancePlan

属性

SuppressMessageAttribute

构造函数

名称	说明
MaintenancePlan()
MaintenancePlan(Package, ServerConnection)
MaintenancePlan(ServerConnection, String)
MaintenancePlan(ServerConnection)

字段

名称	说明
MaintenancePlansFolder

属性

名称	说明
BasePackage
Connections
Description
FromMSX
IsDistributed
LocalServerConnection
LocalServerConnectionName
LocalServerTargeted
MSXServer
Name
OriginalName
Owner
PackageXML
PotentialTargetServers
ReportingOptions
ServerRole
Subplans
SubplansIds
TargetedServerGroups
TargetedServers
TargetServerGroups

方法

名称	说明
AddConnection(String, String)
CanBeDistributed()
DeleteConnection(String)
ExecuteAllSubPlans()
GetMaintenancePlanFromConnectedServer(String, ServerConnection)
GetMaintenancePlanFromServer(String, String, String, SqlSecureString)
GetSubPlanIndexIntoExecutables(String, Int32)
HasConnection(String)
InitializeNewPlanForDesigner()
LoadFromSqlServer(String, ServerConnection)
OnAllMaintPlanJobsArrived(String, String, String, String, Int32)
OnMaintPlanJobArrivedFromMSX(String, String, String)
OnRemovedFromSqlServer()
OnSave()
PlanNameExists(String, ServerConnection)
PreSaveFromUI()
RemoveFromSqlServer()
Rename(String)
Save()