sql server programming: Hi all,

Before I dig into SQLMail, can you tell me if it is built with
"Scheduled/Queued" sending in mind? Can I schedule a certain message to be
smtp'ed in a minute or an hour?

Thanks!

No. You can use a job to schedule an email though using the xp_sendmail
command. There's nothing directly built into SQLMail itself that allows
this. Also, SQLMail uses MAPI, not SMTP. So you can't SMTP anything with
it. There are ways to do this though. www.sqlteam.com has a good example.
[quoted text, click to view]

Hi Guy,

Before you starting digging into SQLMail don't!

If you can, use the one off www.sqldev.net and save a lot of heartache,
wasted time and unrealiability.

You will need to use SQL Server Agent for scheduling mail sends.

--
Tony Rogerson
SQL Server MVP
http://www.sqlserverfaq.com?mbr=21
(Create your own groups, Forum, FAQ's and a ton more)