HOW TO SENT MAIL - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

HOW TO SENT MAIL

Author

Topic

yaman
Posting Yak Master

213 Posts

Posted - 2010-12-10 : 17:28:35

Sir ,

I want to sent mail on time basis .

I have table who have list of members with time like this .

members Mailsent time
A 10.00 A.M.
B 12.20 P.M.
C 10.01 A.M.
I want to sent mail to all members according to time automatically .
Please help me out Sir .

Yaman

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-10 : 17:57:52

For built-in email tools:
You can use Database Mail if you are using SQL Server 2005 or 2008. If you are using SQL Server 2000, then you can use SQL Mail.

If you want to send email on a schedule, then use a SQL Agent job paired with whatever email option you've chosen (like above built-in tools).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

yaman
Posting Yak Master

213 Posts

Posted - 2010-12-10 : 18:11:56

quote:
Originally posted by yaman

quote:
Originally posted by yaman

Thanks for reply Sir .

I am using Database mail to sent mail from sql server 2008 but my problem is how can i send mail at members time like time is stored in table .

member A ---- mail send at 10.00 A.M.
member B ---- mail send at 12.20 P.M.
member C ---- mail send at 10.01 A.M.

i want do this automatically .

Yaman

Yaman

Yaman

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources