Export (0) Print
Expand All
Expand Minimize

<ActionTimeout> Element (<ScheduledRule>)

SQL Server 2000

Specifies an interval during which the Transact-SQL statements specified in the event scheduled <Action> element must complete successfully.

Structure
<SubscriptionClasses>
   <SubscriptionClass>
      ...
      <ScheduledRules>
         <ScheduledRule>
            ...
            <ActionTimeout>

Element Characteristics
Characteristic Description
Data Type duration.
Default Value 30 minutes.
Occurrence Optional once per <ScheduledRule> node.
Updates Can be added, deleted, and modified using NSControl Update.
Element Relationships
Relationship Elements
Parent Node <ScheduledRule> Node
Remarks

If an action does not complete in the time specified by <ActionTimeout>, the action is canceled and an error is recorded in the event log.

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 Scheduled Rules
Show:
© 2014 Microsoft