NotificationClass Element (ADF)

Provides a location for defining one notification class.

Syntaxe

<NotificationClasses>
    <NotificationClass>

Element Characteristics

Characteristic Description

Data type

None.

Default value

None.

Occurrence

Optional once or more per NotificationClasses element.

Updates

Can be added and deleted when updating the application.

Element Relationships

Relationship Elements

Parent element

NotificationClasses Element (ADF)

Child elements

NotificationClassName Element (ADF)

Schema Element for NotificationClass (ADF)

FileGroup Element for NotificationClass (ADF)

ContentFormatter Element (ADF)

DigestDelivery Element (ADF)

MulticastDelivery Element (ADF)

NotificationBatchSize Element (ADF)

Protocols Element (ADF)

ExpirationAge Element (ADF)

Notes

If you delete a notification class, Microsoft SQL Server 2005 Notification Services drops the table for the notification class when you update the application. This deletes any data the table might contain.

If you rename a notification class, Notification Services creates a new notification class and deletes the old notification class.

Exemple

The following example shows a complete definition for a notification class. The notification class provides stock information to subscribers via email over the SMTP protocol.

<NotificationClass>
    <NotificationClassName>StockNotifications</NotificationClassName>
    <Schema>
        <Fields>
            <Field>
                <FieldName>StockSymbol</FieldName>
                <FieldType>char(10)</FieldType>
            </Field>
            <Field>
                <FieldName>StockPrice</FieldName>
                <FieldType>money</FieldType>
            </Field>
        </Fields>
    </Schema>
    <FileGroup>Secondary</FileGroup>
    <ContentFormatter>
        <ClassName>Stock.StockFormatter</ClassName>
        <AssemblyName>C:\CustomCFs\StockFormatter.dll</AssemblyName>
        <Arguments>
            <Argument>
                <Name>OutputHTML</Name>
                <Value>true</Value>
            </Argument>
        </Arguments>
    </ContentFormatter>
    <DigestDelivery>true</DigestDelivery>
    <NotificationBatchSize>100</NotificationBatchSize>
    <Protocols>
        <Protocol>
            <ProtocolName>SMTP</ProtocolName>
            <Fields>
                <Field>
                    <FieldName>Subject</FieldName>
                    <SqlExpression>%SubjectLine%</SqlExpression>
                </Field>
                <Field>
                    <FieldName>From</FieldName>
                    <SqlExpression>%fromAddress%</SqlExpression>
                </Field>
                <Field>
                    <FieldName>To</FieldName>
                    <FieldReference>DeviceAddress</FieldReference>
                </Field>
                <Field>
                    <FieldName>Priority</FieldName>
                    <SqlExpression>%mailPriority%</SqlExpression>
                </Field>
                <Field>
                    <FieldName>BodyFormat</FieldName>
                    <SqlExpression>&quot;html&quot;</SqlExpression>
                </Field>
            </Fields>
            <ProtocolExecutionSettings>
                <RetrySchedule>
                    <RetryDelay>P0DT00H15M00S</RetryDelay>
                    <RetryDelay>P0DT00H30M00S</RetryDelay>
                    <RetryDelay>P0DT01H00M00S</RetryDelay>
                </RetrySchedule>
                <FailuresBeforeAbort>20</FailuresBeforeAbort>
                <MulticastRecipientLimit>10</MulticastRecipientLimit>
                <WorkItemTimeout>P0DT00H30M00S</WorkItemTimeout>
            </ProtocolExecutionSettings>
        </Protocol>
    </Protocols>
    <ExpirationAge>P0DT02H30M00S</ExpirationAge>
</NotificationClass>

Voir aussi

Référence

Application Definition File Reference

Autres ressources

Définition des classes de notification
Mise à jour des instances et des applications

Aide et Informations

Assistance sur SQL Server 2005