"marking" the processed elements in data-driven subscription

I would like to use e-mail delivery for the following scenario: new orders
arrive in a table and i
would like to send confirmation messages which contain the content of the
order. The RS has an "every
5 minutes" schedule and should send e-mail just about the new orders to the
customers.
How could I differentiate the new elements from the old ones?
- or -
How can I "mark" the orders, when the confirmation report was created that
they were processed?
Thanks in advance,
Kolos"Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> I would like to use e-mail delivery for the following scenario: new orders
> arrive in a table and i
> would like to send confirmation messages which contain the content of the
> order. The RS has an "every
> 5 minutes" schedule and should send e-mail just about the new orders to
the
> customers.
> How could I differentiate the new elements from the old ones?
> - or -
> How can I "mark" the orders, when the confirmation report was created
that
> they were processed?
> Thanks in advance,
> Kolos
>
>|||"Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> I would like to use e-mail delivery for the following scenario: new orders
> arrive in a table and i
> would like to send confirmation messages which contain the content of the
> order. The RS has an "every
> 5 minutes" schedule and should send e-mail just about the new orders to
the
> customers.
> How could I differentiate the new elements from the old ones?
> - or -
> How can I "mark" the orders, when the confirmation report was created
that
> they were processed?
> Thanks in advance,
> Kolos
>
>|||'
"Bender" <roman.ilic@.avtenta.si> wrote in message
news:%23%23BJFeHgEHA.3416@.TK2MSFTNGP09.phx.gbl...
> "Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
> news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> > I would like to use e-mail delivery for the following scenario: new
orders
> > arrive in a table and i
> > would like to send confirmation messages which contain the content of
the
> > order. The RS has an "every
> > 5 minutes" schedule and should send e-mail just about the new orders to
> the
> > customers.
> >
> > How could I differentiate the new elements from the old ones?
> > - or -
> > How can I "mark" the orders, when the confirmation report was created
> that
> > they were processed?
> >
> > Thanks in advance,
> > Kolos
> >
> >
> >
>
>|||Hi Kolos,
We do something similar.
We have an additional field in our subscription Queue which has a Processed
Flag field (just a BIT). We update this field whenever the entry has been
processed via the data driven subscription's query. If you don't want to
add a field to this table, you could create an additional table recording a
log of processed Orders.
HTH
Matt
"Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> I would like to use e-mail delivery for the following scenario: new orders
> arrive in a table and i
> would like to send confirmation messages which contain the content of the
> order. The RS has an "every
> 5 minutes" schedule and should send e-mail just about the new orders to
the
> customers.
> How could I differentiate the new elements from the old ones?
> - or -
> How can I "mark" the orders, when the confirmation report was created
that
> they were processed?
> Thanks in advance,
> Kolos
>
>|||That's on the right track, but I'd like to also point out that an easy way
to update the "flag" field is to use a stored procedure. Within the sproc
you can return the records affected by the email notice and revisit each row
to update the flag value. =)
Matt
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ucN2OnDrEHA.868@.TK2MSFTNGP10.phx.gbl...
> Hi Kolos,
> We do something similar.
> We have an additional field in our subscription Queue which has a
> Processed
> Flag field (just a BIT). We update this field whenever the entry has been
> processed via the data driven subscription's query. If you don't want to
> add a field to this table, you could create an additional table recording
> a
> log of processed Orders.
> HTH
> Matt
> "Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
> news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
>> I would like to use e-mail delivery for the following scenario: new
>> orders
>> arrive in a table and i
>> would like to send confirmation messages which contain the content of the
>> order. The RS has an "every
>> 5 minutes" schedule and should send e-mail just about the new orders to
> the
>> customers.
>> How could I differentiate the new elements from the old ones?
>> - or -
>> How can I "mark" the orders, when the confirmation report was created
> that
>> they were processed?
>> Thanks in advance,
>> Kolos
>>
>|||lol, actually, I do use a stored procedure. I was being just more general
and wasn't sure of Kolos's particular scenario.
"Matt Temple" <mtemple@.dslextreme.com> wrote in message
news:10q9p1l72kj6iaa@.corp.supernews.com...
> That's on the right track, but I'd like to also point out that an easy way
> to update the "flag" field is to use a stored procedure. Within the sproc
> you can return the records affected by the email notice and revisit each
row
> to update the flag value. =)
> Matt
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ucN2OnDrEHA.868@.TK2MSFTNGP10.phx.gbl...
> > Hi Kolos,
> >
> > We do something similar.
> >
> > We have an additional field in our subscription Queue which has a
> > Processed
> > Flag field (just a BIT). We update this field whenever the entry has
been
> > processed via the data driven subscription's query. If you don't want
to
> > add a field to this table, you could create an additional table
recording
> > a
> > log of processed Orders.
> >
> > HTH
> >
> > Matt
> >
> > "Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
> > news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> >> I would like to use e-mail delivery for the following scenario: new
> >> orders
> >> arrive in a table and i
> >> would like to send confirmation messages which contain the content of
the
> >> order. The RS has an "every
> >> 5 minutes" schedule and should send e-mail just about the new orders to
> > the
> >> customers.
> >>
> >> How could I differentiate the new elements from the old ones?
> >> - or -
> >> How can I "mark" the orders, when the confirmation report was created
> > that
> >> they were processed?
> >>
> >> Thanks in advance,
> >> Kolos
> >>
> >>
> >>
> >
> >
>

"Data-Driven Subscription" Not Showing

Hi,
Just a follow-up on my earlier email.
I have Reporting Services 2000 installed on Small Business Server for
Windows 2003.
I am logged on as admistrator and all permissions for Content Manager ans
System Admistrator are in place
When I Go To Subscriptions in Report Manager, "New Subscription" option only
shows.
I know that there should be a "New Data-Driven Subscription" option showing
right next to this.
But it just does not show. Does nayone know why this is not the case.
Does this appear only with SQL Reporting Services 2000 Service Pack 1 only?
Or is some option that needs to be ticked off somehwere for this to show.
Does anyone know why this option just will now show?
Thanks
SanjeevWhen I looked into the same problem, I was told that Data Driven
Subscriptions are only available with the Enterprise Edition of SQL Server.
"Sanjeev" <sanjeev@.microsoft.com> wrote in message
news:uh1UhJX%23FHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Just a follow-up on my earlier email.
> I have Reporting Services 2000 installed on Small Business Server for
> Windows 2003.
> I am logged on as admistrator and all permissions for Content Manager ans
> System Admistrator are in place
> When I Go To Subscriptions in Report Manager, "New Subscription" option
> only shows.
> I know that there should be a "New Data-Driven Subscription" option
> showing right next to this.
> But it just does not show. Does nayone know why this is not the case.
> Does this appear only with SQL Reporting Services 2000 Service Pack 1
> only?
> Or is some option that needs to be ticked off somehwere for this to show.
> Does anyone know why this option just will now show?
> Thanks
> Sanjeev
>|||Thanks for the assist Susan.
Did you ever try using Enterprise Edition to see if that solved the problem
Sanjeev
"Susan" <sfischer@.csg-llc.com> wrote in message
news:%230EDmmb%23FHA.2040@.TK2MSFTNGP14.phx.gbl...
> When I looked into the same problem, I was told that Data Driven
> Subscriptions are only available with the Enterprise Edition of SQL
> Server.
>
> "Sanjeev" <sanjeev@.microsoft.com> wrote in message
> news:uh1UhJX%23FHA.1988@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> Just a follow-up on my earlier email.
>> I have Reporting Services 2000 installed on Small Business Server for
>> Windows 2003.
>> I am logged on as admistrator and all permissions for Content Manager ans
>> System Admistrator are in place
>> When I Go To Subscriptions in Report Manager, "New Subscription" option
>> only shows.
>> I know that there should be a "New Data-Driven Subscription" option
>> showing right next to this.
>> But it just does not show. Does nayone know why this is not the case.
>> Does this appear only with SQL Reporting Services 2000 Service Pack 1
>> only?
>> Or is some option that needs to be ticked off somehwere for this to show.
>> Does anyone know why this option just will now show?
>> Thanks
>> Sanjeev
>>
>