Message to Email

27 Jul 2006 4:50 PM

Carlos

I need to create a SP that send a message to the Order register Operator,
when the price for some article are lower than a value,

can someone help me with this ??

The query is
SELECT Preco
FROM OrdLin
WHERE Art LIKE 'E123%' AND
Preco < 15

The Operator Table is OperSist and the Email is some***@company.org

Thanks

27 Jul 2006 5:55 PM

Mike C#

Check out http://www.sqldev.net/xp/xpsmtp.htm

Show quote

"Carlos" <Car***@discussions.microsoft.com> wrote in message
news:1CEF24BE-FF22-4719-8EBA-022367A1CF22@microsoft.com...
>I need to create a SP that send a message to the Order register Operator,
> when the price for some article are lower than a value,
>
> can someone help me with this ??
>
> The query is
> SELECT Preco
> FROM OrdLin
> WHERE Art LIKE 'E123%' AND
> Preco < 15
>
> The Operator Table is OperSist and the Email is some***@company.org
>
> Thanks

27 Jul 2006 6:11 PM

Carlos

Yes !!
I've already configure it and make it in use, but only with a txt file in
the pickup folder, however i cant't put the query result in the file

But thank's anyway

Show quote

"Mike C#" wrote:

> Check out http://www.sqldev.net/xp/xpsmtp.htm
>
> "Carlos" <Car***@discussions.microsoft.com> wrote in message
> news:1CEF24BE-FF22-4719-8EBA-022367A1CF22@microsoft.com...
> >I need to create a SP that send a message to the Order register Operator,
> > when the price for some article are lower than a value,
> >
> > can someone help me with this ??
> >
> > The query is
> > SELECT Preco
> > FROM OrdLin
> > WHERE Art LIKE 'E123%' AND
> > Preco < 15
> >
> > The Operator Table is OperSist and the Email is some***@company.org
> >
> > Thanks
>
>
>

27 Jul 2006 10:09 PM

Terri

Depending on your query results you can set the xp_smtp_sendmail @subject
and @message parameters to your query results. Can be ugly if your results
are long. You can also INSERT your results into table or global temporary
table and bcp the results to a text file. Then attach the text file.

Show quote

"Carlos" <Car***@discussions.microsoft.com> wrote in message
news:0DF3C2CD-1080-400D-85A2-84A89D7111B5@microsoft.com...
> Yes !!
> I've already configure it and make it in use, but only with a txt file in
> the pickup folder, however i cant't put the query result in the file
>
> But thank's anyway
>
> "Mike C#" wrote:
>
> > Check out http://www.sqldev.net/xp/xpsmtp.htm
> >
> > "Carlos" <Car***@discussions.microsoft.com> wrote in message
> > news:1CEF24BE-FF22-4719-8EBA-022367A1CF22@microsoft.com...
> > >I need to create a SP that send a message to the Order register
Operator,
> > > when the price for some article are lower than a value,
> > >
> > > can someone help me with this ??
> > >
> > > The query is
> > > SELECT Preco
> > > FROM OrdLin
> > > WHERE Art LIKE 'E123%' AND
> > > Preco < 15
> > >
> > > The Operator Table is OperSist and the Email is some***@company.org
> > >
> > > Thanks
> >
> >
> >