Help : Performance due to SQL Mail

Dear All,
I have a sql job that checking incoming email by using xp_findnextmsg,
read the incoming email then reply the sender with query result.
I schedule the job every minute.
My question is:
Does the job will make my sql server perfomance down?
Thanks
Robert Lie
Hi
The job itself, no. But test in your environment as to what affects your own
code you wrote causes on locking and blocking on your tables.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1121049371.109507.159220@.g14g2000cwa.googlegr oups.com...
> Dear All,
> I have a sql job that checking incoming email by using xp_findnextmsg,
> read the incoming email then reply the sender with query result.
> I schedule the job every minute.
> My question is:
> Does the job will make my sql server perfomance down?
> Thanks
> Robert Lie
>