Export (0) Print
Expand All
Expand Minimize

<Interval> Element

SQL Server 2000

Specifies how frequently after the initial start time the event provider is triggered to run.

Structure
<Providers>
   <HostedProvider>
      ...
      <Schedule>
         ...
         <Interval>

Element Characteristics
Characteristic Description
Data Type duration.
Default Value None.
Occurrence Required once per /HostedProvider/Schedule node.
Updates Can be modified, but not added or deleted, using NSControl Update.
Element Relationships
Relationship Elements
Parent Node <Schedule> Node (<HostedProvider>)
Remarks

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.

Important  The value you specify for the interval must divide evenly within a 24-hour period. For instance, 15 minutes is a valid interval, causing the event provider to run 96 times within a 24-hour period. However, 14 minutes is not a valid interval, because it implies that the event provider should run 102.86 times within a 24-hour period, which does not divide evenly within a 24-hour period.

See Also
Defining the Event Provider Schedule
Show:
© 2014 Microsoft