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

<Interval> Element

SQL Server 2000

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


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

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