Schedule Jobs

[Peter]

I have a problem about ASP. The problem is how to schedule jobs or execute
send email function everyday if the condition is valid which comes from the
database.

The situation is how to write the reminder via email. I am using SQL Server
7.0. (Like yahoo's calendar which has a function to remind the user something
or events will happen!) How to do this? Should I only using ASP script to
do this or using SQL server to do this ?

I know SQL server has SQL Mail, but the fact is it connot support MS Outlook
Express. So, what should I do ? Thx.

[Rob Taylor]

You need to set a trigger on SQL Server to send the mail.
I do not know what you mean as far as SQL Mail not supporting outlook. That
should not matter. You can alsu use the Windows Script Host.



"Peter" <saiips@hongkong.com> wrote:
>
>I have a problem about ASP. The problem is how to schedule jobs or execute
>send email function everyday if the condition is valid which comes from
the
>database.
>
>The situation is how to write the reminder via email. I am using SQL Server
>7.0. (Like yahoo's calendar which has a function to remind the user something
>or events will happen!) How to do this? Should I only using ASP script to
>do this or using SQL server to do this ?
>
>I know SQL server has SQL Mail, but the fact is it connot support MS Outlook
>Express. So, what should I do ? Thx.