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