EventRules Element (ADF)

Provides a location for all of the subscription event rule definitions for one subscription class.

Syntaxe

<SubscriptionClasses>
    <SubscriptionClass>
        ...
        <EventRules>

Element Characteristics

Element Relationships

Exemple

The following example shows an EventRules element and its child elements. The rule creates event-driven notifications, and also loads notification data into the StockSubscriptionChron table. It is executed whenever an event batch containing events of the StockEvents class is processed. This rule is permitted one minute to complete successfully.

<EventRules>
    <EventRule>
        <RuleName>StockSubscriptionEventRule</RuleName>
        <Action>
        -- Generate notifications from event and chronicle data
        INSERT INTO StockNotifications 
        ( SubscriberId, DeviceName, SubscriberLocale,
          StockSymbol, StockPrice )
        SELECT S.SubscriberId, S.DeviceName,
          S.SubscriberLocale, E.StockSymbol, E.StockPrice
        FROM StockSubscriptions S JOIN StockEvents E
        ON S.StockSymbol = E.StockSymbol
        JOIN StockEventChron C
        ON S.StockSymbol = C.StockSymbol
        WHERE S.StockTriggerPrice &lt;= E.StockPrice
        AND S.StockTriggerPrice &gt; C.StockHighPrice
        -- Update subscription chronicle
        INSERT StockSubscriptionChron
        (SubscriberId, StockSymbol, StockPrice)
        SELECT S.SubscriberId, S.StockSymbol, E.StockPrice
        FROM StockSubscriptions S JOIN StockEvents E
        ON S.StockSymbol = E.StockSymbol
        </Action>
        <ActionTimeout>P0DT00H01M00S</ActionTimeout>
        <EventClassName>StockEvents</EventClassName>
    </EventRule>
</EventRules>

Voir aussi

Référence

Application Definition File Reference

Autres ressources

Définition de règles d'événement
Mise à jour des instances et des applications

Aide et Informations

Assistance sur SQL Server 2005