> Brett_A wrote:
> > I need to send an automated email each day (Member expiration
> > notices).  The data sits in an SQL Server but SQL Mail is not
> > available.
>
> > Building an .asp page that makes this happen isn't a problem, but that
> > page would have to be loaded each day for the  process to run.
>
> > Any ideas on how to make this happen?
>
> > Thanks
>
> > Brett
>
> Set up scheduled job and use this activex:
>
> Dim WshShell
> Set WshShell =CreateObject("WScript.Shell")
> WshShell.Run ("http://www.yourwebsitecom/yourpage.asp")
> Set WsShell = Nothing
>
> It works nicely for me.
>
> Steve

> Brett_A wrote:
> > Can you point me to more information about how to do this?
>
> Hi Brett,
> In Enterprise Manager expand the Management Tab, then the SQL Server
> Agent Tab and click on Jobs. Now right click on Jobs and create a new one.
>
> Give it a name, and then click on the Steps tab. Click on New, name the
> step and then select Active X Script from the type list. Copy and paste
> the code into command text area and amend the script to suit your page.
> When done click ok and then go into the schedule tab and set it up
> correctly.
>
> That should be all you need to do.
>
> Steve