Auto mail from SQL

[Umar]

Hi

can any one tell me that how i can send email to my registered clients
from sql store procedure if they meet some specific critaria. and this
store procedure will automaticelly execuate after every 10 minutes and
check the database. if any client meet the critari specified a mail
will be send to that client.


thanx

[Siva M]

Re: Auto mail from SQL

Assuming you are using SQL Server, create a stored proc that uses
xp_sendmail stored procedure to send mails. The schedule your stored proc
using SQL Server job scheduler.

For the later part:

http://www.aspfree.com/c/a/Database-Code/How-to-setup-a-stored-procedure-to-be-automatically-run/

"Umar" <me.crimemaster @gmail.comwrote in message
news:1156405730 .597839.168170@ i42g2000cwa.goo glegroups.com.. .
Hi

can any one tell me that how i can send email to my registered clients
from sql store procedure if they meet some specific critaria. and this
store procedure will automaticelly execuate after every 10 minutes and
check the database. if any client meet the critari specified a mail
will be send to that client.


thanx