Auto mail from SQL

  • Thread starter Thread starter Umar
  • Start date Start date
U

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
 
From an sp? Assuming SQL Server...
from sql store procedure if they meet some specific critaria. SELECT...WHERE...
and this store procedure will automaticelly execuate after every 10
minutes
Click to expand...
either WAITFOR or an agent-scheduled task
a mail will be send to that client
Click to expand...
either a CURSOR or a loop over the SELECT results, and xp_sendmail

Seriously, though, see my previous reply - this is the wrong ng. This is a
C# group. You will get better replies from a more appropriate group.

Marc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto mail from SQL 1
service dependency on a *specific* sql server database 4
Reading the custom error messages from SQL 1
How to execute SQL strored procedure from Access 6
Sql Code generation tools 16
case sensitive database and sql command parameters 2
MSI for create database and execute scripts 1
Save off attachment and start SQL stored procedure 3

Back
Top