2.7.1.11.1.1.1.9 MaintenanceTaskBaseAttributeGroup

The MaintenanceTaskBaseAttributeGroup attribute group specifies the attributes that are used by the SqlTaskData element by all maintenance plan tasks. The attributes that are specified in this section MUST NOT be used unless the task is one of the maintenance plan tasks.

The following is the XSD for the MaintenanceTaskBaseAttributeGroup attribute group.

  <xs:attributeGroup name="MaintenanceTaskBaseAttributeGroup">
    <xs:attribute name="ServerVersion" type="xs:int"/>
    <xs:attribute name="ExtendedLogging">
      <xs:simpleType>
        <xs:restriction base="xs:string">
          <xs:enumeration value="True"/>
          <xs:enumeration value="False"/>
        </xs:restriction>
      </xs:simpleType>
    </xs:attribute>
    <xs:attribute name="LocalConnectionForLogging" type="xs:string"/>
    <xs:attribute name="TaskName" type="xs:string"/>
    <xs:attribute name="IgnoreDatabasesInNotOnlineState">
      <xs:simpleType>
        <xs:restriction base="xs:string">
          <xs:enumeration value="True"/>
          <xs:enumeration value="False"/>
        </xs:restriction>
      </xs:simpleType>
    </xs:attribute>
  </xs:attributeGroup>

The following table specifies additional information for the attributes of the MaintenanceTaskBaseAttributeGroup attribute group.

Attribute

Description

ServerVersion

An integer value that specifies the server version.

ExtendedLogging

An enumeration value that specifies whether to include additional information about server operation at the end of a successful execution of a maintenance task in the log file.

"True" specifies that additional information is included in the log file.

"False" specifies that additional information is not included in the log file.

LocalConnectionForLogging

A string value that specifies a local connection manager that is used for logging. The string can reference the connection manager by pointing to the DTSID property of the connection manager or to the ObjectName property of the connection manager.

TaskName

A string value that specifies the name of the task.

IgnoreDatabasesInNotOnlineState

An enumeration value that specifies whether databases that are not in the online state are ignored.

"True" specifies that databases that are not in the online state are ignored.

"False" specifies that databases that are not in the online state are not ignored.