microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Event Not Being Added To Rule and Event Table

Subject: Re: Event Not Being Added To Rule and Event Table
From:
Date: 10 Apr 2006 06:05:51 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
I had trim the code here is the complete subscription class, here is a
more complete code segment. Since I had run the subscription class
before adding the event will that cause a problem? Shouls the service
be running or does it not matter?

<SubscriptionClasses>
  <SubscriptionClass>

<SubscriptionClassName>TemporaryAccessSubscription</SubscriptionClassName>
   <Schema>
        <Field>
            <FieldName>DeviceName</FieldName>
            <FieldType>nvarchar(255)</FieldType>
            <FieldTypeMods>not null</FieldTypeMods>
        </Field>
        <Field>
           <FieldName>SubLocale</FieldName>
           <FieldType>varchar(10)</FieldType>
           <FieldTypeMods>not null</FieldTypeMods>
        </Field>
        <Field>
           <FieldName>User</FieldName>
           <FieldType>nvarchar(15)</FieldType>
           <FieldTypeMods>not null</FieldTypeMods>
        </Field>
        <Field>
           <FieldName>emailDate</FieldName>
           <FieldType>datetime</FieldType>
           <FieldTypeMods>not null</FieldTypeMods>
        </Field>
    </Schema>
    <EventRules>
       <EventRule>
          <RuleName>TempAccessRule</RuleName>
             <Action>
                 SELECT S.SubscriberId, S.DeviceName, S.SubLocale, E.User,
             E.EmailDate
                FROM TempAccess E, TemporaryAccessSubscription S
                WHERE S.User = E.User
              </Action>
        </EventRule>
</EventRules>
</SubscriptionClass>
        </SubscriptionClasses>

Thanks,
Clank


<Prev in Thread] Current Thread [Next in Thread>