Automating tasks

[Kikuyu]

I have a simple auction site (written in ASP with Access
database running on Windows 2000 server with IIS) and I
want to automatically send an email to auction
participants when the auction has ended.

The end date of an auction is stored in a table in the
Access database. Is there a best practice to
automatically read this date to send an email?

Please reply by email and any ideas are welcome even if it
requires additional programming using some other
application.

Thanks!

[Kikuyu]

I have a simple auction site (written in ASP with Access
database running on Windows 2000 server with IIS) and I
want to automatically send an email to auction
participants when the auction has ended.

The end date of an auction is stored in a table in the
Access database. Is there a best practice to
automatically read this date to send an email?

Please reply by email and any ideas are welcome even if it
requires additional programming using some other
application.

Thanks!

[Ray at]

Use the task scheduler on your server to check for any auctions that ended
that day. Like, if your auctions can end any day of the week and the cutoff
time is midnight, schedule a task to run every night at midnight.

Replies stay in the group.

Ray at work

"Kikuyu" <kikuyu.daniels@modicom-removethis-.com> wrote in message
news:0cca01c3dabe$6f890d00$a501280a@phx.gbl...

> I have a simple auction site (written in ASP with Access
> database running on Windows 2000 server with IIS) and I
> want to automatically send an email to auction
> participants when the auction has ended.
>
> The end date of an auction is stored in a table in the
> Access database. Is there a best practice to
> automatically read this date to send an email?
>
> Please reply by email and any ideas are welcome even if it
> requires additional programming using some other
> application.
>
> Thanks!

[Terry Murray]

I this task scheduler available in Windows XP Pro. And if so where do I find
it?

Thanks

Terry

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uPfktDs2DHA.2948@TK2MSFTNGP09.phx.gbl...

> Use the task scheduler on your server to check for any auctions that ended
> that day. Like, if your auctions can end any day of the week and the

cutoff

> time is midnight, schedule a task to run every night at midnight.
>
> Replies stay in the group.
>
> Ray at work
>
> "Kikuyu" <kikuyu.daniels@modicom-removethis-.com> wrote in message
> news:0cca01c3dabe$6f890d00$a501280a@phx.gbl...

> > I have a simple auction site (written in ASP with Access
> > database running on Windows 2000 server with IIS) and I
> > want to automatically send an email to auction
> > participants when the auction has ended.
> >
> > The end date of an auction is stored in a table in the
> > Access database. Is there a best practice to
> > automatically read this date to send an email?
> >
> > Please reply by email and any ideas are welcome even if it
> > requires additional programming using some other
> > application.
> >
> > Thanks!

>
>

[Ray at]

Yes, it's in the control panel. Or you can schedule tasks with the AT task
scheduler at the command prompt. Enter AT /? for info.

Ray at home

"Terry Murray" <tgmurray@rogers.com> wrote in message
news:hbmNb.30861$%wh.104@news04.bloor.is.net.cable .rogers.com...

> I this task scheduler available in Windows XP Pro. And if so where do I

find

> it?
>
> Thanks
>
> Terry
>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:uPfktDs2DHA.2948@TK2MSFTNGP09.phx.gbl...

> > Use the task scheduler on your server to check for any auctions that

ended

> > that day. Like, if your auctions can end any day of the week and the

> cutoff

> > time is midnight, schedule a task to run every night at midnight.
> >
> > Replies stay in the group.
> >
> > Ray at work
> >
> > "Kikuyu" <kikuyu.daniels@modicom-removethis-.com> wrote in message
> > news:0cca01c3dabe$6f890d00$a501280a@phx.gbl...

> > > I have a simple auction site (written in ASP with Access
> > > database running on Windows 2000 server with IIS) and I
> > > want to automatically send an email to auction
> > > participants when the auction has ended.
> > >
> > > The end date of an auction is stored in a table in the
> > > Access database. Is there a best practice to
> > > automatically read this date to send an email?
> > >
> > > Please reply by email and any ideas are welcome even if it
> > > requires additional programming using some other
> > > application.
> > >
> > > Thanks!

> >
> >

>
>

[David Morgan]

Beautiful. I would go one step further and shell from ASP to WSCript and
copy an "auction ends" .vbs and then schedule it to run at the auction end
time, then delete itself.

I have always wondered how E-Bay do it.... Do you think they poll every
second for completing auctions or set up a task when the auction is created.
You will note you cannot change the auction end time.


"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uPfktDs2DHA.2948@TK2MSFTNGP09.phx.gbl...

> Use the task scheduler on your server to check for any auctions that ended
> that day. Like, if your auctions can end any day of the week and the

cutoff

> time is midnight, schedule a task to run every night at midnight.
>
> Replies stay in the group.
>
> Ray at work
>
> "Kikuyu" <kikuyu.daniels@modicom-removethis-.com> wrote in message
> news:0cca01c3dabe$6f890d00$a501280a@phx.gbl...

> > I have a simple auction site (written in ASP with Access
> > database running on Windows 2000 server with IIS) and I
> > want to automatically send an email to auction
> > participants when the auction has ended.
> >
> > The end date of an auction is stored in a table in the
> > Access database. Is there a best practice to
> > automatically read this date to send an email?
> >
> > Please reply by email and any ideas are welcome even if it
> > requires additional programming using some other
> > application.
> >
> > Thanks!

>
>