Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 to send automated mail every day

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-04-11 : 09:29:46
raghu r writes "i am creating a service in Sql Server Agent, this service will send mails every day depending upon a query result.
i am working on project Library management in .net.i am using Sql server as backend.

i am not using OUTLOOK.
the query result is a set of records which contain the e-mail address and the books the members have to return. we get the result records if the duedate field in the record matches with todays date.
with the results i get i want to send mails to all.
pls help me"

bakerjon
Posting Yak Master

145 Posts

Posted - 2006-04-11 : 13:32:36
What about Notification Services? This feature seems to be right in line with what you are trying to write. Why re-invent the wheel?



Jon

Holding it down on the engineering tip, y'all!

http://www.sqljunkies.com/weblog/outerjoin
Go to Top of Page
   

- Advertisement -