If I have emails stored in a table, it is possible for DTS to schedule the
task to send out those emails?? Some people told me to use DTS for
scheduling jobs?

Please advise. Thanks!!

What do you mean by emails stored in a table. Do you mean the composite
info required for an Email i.e., To, From, Message etc.

You could certainly use DTS

You would loop on the information in the table and then populate the
properties of the Sendmail task each time. You could also do this without
DTS using a cursor.

DTS has nothing to do with Scheduling. SQL Server Agent or A.N.Other
Scheduling tool is required to schedule packages.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Matt" <mattloude (AT) hotmail (DOT) com> wrote

Onething that i would like to know before suggesting a solution - what
exactly do you have in your database?

Is it just the fields and you want to construct an email and send it out?
If so, then you need to write a program that will fetch the data from the
table, construct the email and send it using any mail program or SMTP

If not and if your table has columns like TO, FROM etc., then you can
certainly use DTS. However, if you want to have it predefined to run at
select frequencies, then you might like to rope in a third party product or
inbuilt services of SQL Server Agent.

Both ways, you can achieve the desired functionality.

Sanchan [MSFT]

sanchans (AT) online (DOT) microsoft.com

This posting is provided "AS IS" with no warranties, and confers no rights.