By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,338 Members | 1,346 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,338 IT Pros & Developers. It's quick & easy.

batch job for mailing out hundreds of mails....

P: n/a
Hi, I like to ask what can be an ideal solution for this type of situation?
We need to schedule a job every night that will basically extract data from
the DB and mail that out to our clients. I am thinking of creating DTS
package and using VBscript to instantiate SMTP object or creating a
standardalone EXE that will basically do the same thing. I was wondering
if there are any other better way to do this like using webservices or other
technology that I can take advantage of. Thanks for you help.


Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Cheong,

You can look into the task scheduling API to see how you can register
your program/component to have tasks run on it after a pre-determined amount
of time. DTS and Web Services wouldn't really help here. When your
component is involed through the task scheduling API, you would just query
the database, and perform the emailing as you need to.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- ni**************@exisconsulting.com

"Cheong Sin" <si****@myway.com> wrote in message
news:eC**************@TK2MSFTNGP11.phx.gbl...
Hi, I like to ask what can be an ideal solution for this type of situation? We need to schedule a job every night that will basically extract data from the DB and mail that out to our clients. I am thinking of creating DTS
package and using VBscript to instantiate SMTP object or creating a
standardalone EXE that will basically do the same thing. I was wondering
if there are any other better way to do this like using webservices or other technology that I can take advantage of. Thanks for you help.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.