<Duration> Element
Collapse the table of content
Expand the table of content

<Duration> Element

SQL Server 2000

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


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>)

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
© 2016 Microsoft