Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

<Duration> Element

SQL Server 2000

Specifies how long the vacuumer will continue to run after it has been started.

Structure
<ApplicationExecutionSettings>
   ...
   <Vacuum>
      ...
      <VacuumSchedule>
         <Schedule>
            ...
            <Duration>

Element Characteristics
Characteristic Description
Data Type duration.
Default Value 6 hours, or until the start of the next vacuuming interval, whichever comes first.
Occurrence Optional once per /ApplicationExecutionSettings/Vacuum/VacuumSchedule/Schedule node.
Updates Can be added, deleted, and modified using NSControl Update.
Element Relationships
Relationship Elements
Parent Node <Schedule> Node (<VacuumSchedule>)
Remarks

The <Duration> element specifies the length of the vacuuming period. Vacuuming occurs daily, so the <Duration> value cannot exceed 24 hours.

The format of the XML duration data type is P0DT00H00M00S. For more information about XML data types, see Primitive XML Data Types in the Microsoft MSDN® Library.

See Also
Defining the <Vacuum> Node
Show:
© 2015 Microsoft