DatabaseMaintenanceBaseTask Class

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.Task
      Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask
        Microsoft.SqlServer.Management.DatabaseMaintenance.DatabaseMaintenanceBaseTask
          More...

Namespace:  Microsoft.SqlServer.Management.DatabaseMaintenance
Assembly:  Microsoft.SqlServer.MaintenancePlanTasks (in Microsoft.SqlServer.MaintenancePlanTasks.dll)

[StrongNameIdentityPermissionAttribute(SecurityAction.LinkDemand, PublicKey = "0024000004800000940000000602000000240000525341310004000001000100272736ad6e5f9586bac2d531eabc3acc666c2f8ec879fa94f8f7b0327d2ff2ed523448f83c3d5c5dd2dfc7bc99c5286b2c125117bf5cbe242b9d41750732b2bdffe649c6efb8e5526d526fdd130095ecdb7bf210809c6cdad8824faa9ac0310ac3cba2aa0523567b2dfa7fe250b30facbd62d4ec99b94ac47c7d3b28f1f6e4c8")]
public class DatabaseMaintenanceBaseTask : ExecuteSQLTask, 
	IDatabaseMaintenanceBaseTaskInterface, IDTSComponentPersist, IDTSDowngradableObject

The DatabaseMaintenanceBaseTask type exposes the following members.

  NameDescription
Public propertyBypassPrepareGets or sets a Boolean that indicates whether the Execute SQL task skips preparation of the statement when sending the SQL statement to the relational database management system (RDBMS). (Inherited from ExecuteSQLTask.)
Public propertyCodePageGets or sets the code page to use when translating variable values that are stored as Unicode wide chars to multi-bytes. Translation occurs either when storing values to or extracting values from databases. (Inherited from ExecuteSQLTask.)
Public propertyConnectionGets or sets the name of the connection manager that connects to the relational database management system (RDBMS) where the Execute SQL task is run. (Inherited from ExecuteSQLTask.)
Public propertyDatabaseSelectionType
Public propertyExecutionValueReturns the number of rows affected by the SQL statement or statements. (Inherited from ExecuteSQLTask.)
Public propertyExtendedLogging
Public propertyIgnoreDatabasesInNotOnlineState
Public propertyIsStoredProcedureGets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure. (Inherited from ExecuteSQLTask.)
Public propertyLocalConnectionForLogging
Public propertyObjectTypeSelection
Public propertyParameterBindingsReturns an object that implements IDTSParameterBindings. (Inherited from ExecuteSQLTask.)
Public propertyResultSetBindingsReturns an object that implements IDTSParameterBindings. (Inherited from ExecuteSQLTask.)
Public propertyResultSetTypeGets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs. (Inherited from ExecuteSQLTask.)
Public propertyRunId
Public propertySelectedDatabases
Public propertySelectedTables
Public propertyServerVersion
Protected propertySqlBatchCommands
Public propertySqlStatementSourceGets or sets the name of the source that contains the SQL statement that the Execute SQL task runs. (Inherited from ExecuteSQLTask.)
Public propertySqlStatementSourceTypeGets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs. (Inherited from ExecuteSQLTask.)
Public propertyTableSelectionType
Public propertyTaskConnectionName
Public propertyTaskName
Public propertyTaskNameWasModified
Public propertyTimeOutGets or sets an integer that indicates the maximum number of seconds the task can run before timing out. (Inherited from ExecuteSQLTask.)
Public propertyTypeConversionModeGets or sets the conversion mode used by the Execute SQL Task. (Inherited from ExecuteSQLTask.)
Public propertyVersion*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only. (Inherited from Task.)
Top

  NameDescription
Public methodCanDowngradeTo
Public methodCanUpdate*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML. (Inherited from Task.)
Public methodCopyTo
Public methodDowngradeTo
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodExecute (Overrides ExecuteSQLTask.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Protected methodFinalize (Inherited from Object.)
Public methodGetConnectionIDGets a String containing the ID of the connection. (Inherited from Task.)
Public methodGetConnectionNameGets a String containing the name of the connection. (Inherited from Task.)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetType (Inherited from Object.)
Public methodInitializeTask (Overrides ExecuteSQLTask.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker).)
Public methodLoadFromXML
Protected methodMemberwiseClone (Inherited from Object.)
Public methodOnAddedToTaskHost
Public methodSaveToXML
Public methodToString (Inherited from Object.)
Public methodUpdate*** Member deprecated; see Remarks. ***   This method updates the old package XML with the new package XML if CanUpdate is set to true. (Inherited from Task.)
Public methodValidate (Overrides ExecuteSQLTask.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)
Protected methodWriteToDTSLog
Top

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.Task
      Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask
        Microsoft.SqlServer.Management.DatabaseMaintenance.DatabaseMaintenanceBaseTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceBackupTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceCheckIntegrityTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceDefragmentIndexTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceExecuteAgentJobTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceFileCleanupTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceHistoryCleanupTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceNotifyOperatorTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceReindexTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceShrinkTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceTSQLExecuteTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceUpdateStatisticsTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.ReportingTask
          Microsoft.SqlServer.Management.DatabaseMaintenance.SubPlanPostExecuteTask
Show: