I need to send email out regularly and they don't allow me to use SQL Mail
or use sp_OACreate.

So, the only option I can see is to have the web page to send email. How do
I create a job to call that web page?

The last option I can do is using the Window scheduler which I don't want to
use.

Thanks,

CDonts?
This is a favourite of most people.

http://www.sqldev.net/xp/xpsmtp.htm

17.5K companies are using this.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"zPaul" <~pyoon (AT) phnip (DOT) com> wrote

They are saying that it is a security problem. So they won't let us execute
anything on master database.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

In message <O8xmk743DHA.1392 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, zPaul
<~pyoon (AT) phnip (DOT) com> writes
Sending mail could be seen as a security risk, but if you need
functionality to support the "business", then the "business" needs to be
aware of the risks, understand them fully and accept them, then kick
obstructive admins.

Since this is the DTS group, can you not use CDONTS within an ActiveX
Script Task?


The option of using a job also means you could use an ActiveX job step
to call CDONTS.

If you really want to call a web page from ActiveX SCript, either a job
or DTS, you can use the ServerXMLHTTP component included in MS XML 4.
Here is a simple sample of a GET request as you might perform one inside
an ActiveX Script Task in DTS. It supports POST as well, so you can send
and receive. It is also fully aware of XML which is nice if that is what
you
are transferring.

Get the MSXML SDK (help file) or search MSDN for full details of
ServerXMLHTTP.


Dim xmlHTTP
Dim sURL

sURL = "http://someotherserver/respond.asp?Param1=" &
DTSGlobalVariables("MyVar").Value

Set xmlHTTP = CreateObject ("MSXML2.ServerXMLHTTP.4.0")
xmlHTTP.open "GET",, False
xmlHTTP.send ()
MsgBox xmlHTTP.responseXML.xml

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org