Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

<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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.