How to create a reminder service?

[ruxshin]

Hi,

I'm developing a web-based calendar. I want to create a reminder feature, which will remind the user about a forthcoming event on a user-specified time interval. Is there a way to do this using ASP or VBScript?

I know that it is possible with ColdFusion using its scheduling engine. Is it possible for ASP?


ruxshin

 

[xcata]

It depends what sql engine you use. If you use Microsoft Sql
server it has support for sending mail directly with xp_sendmail. all you have to do is to create a procedure with the logic of your needs. After that you make a job who execute this procedure as often as you like.

If you don't have sql server or don't wont to make use of it you may use Windows scripting host to call your asp page. The wsh may be programmed to be executed periodicly with the nt command "at".

 

[ruxshin]

Hi,

My web-based calendar is meant for multiple users. A user will schedule an activity or event and then can set a reminder (email or windows pop-up) to remind him of the forthcoming event. How do I make use of the WSH to achieve this? How do I call the WSH from the ASP page where the user configure the reminder? Is the nt command "AT" able to schedule reminder once, daily, weekly, or at a specified time?


ruxshin

 

[xcata]

Hi,

Yes, nt "at" command may be used to schedule how do you want. It has flags for each type of schedule you need (see windows nt/2000 help).

If you want complete examples look at

http://www.4guysfromrolla.com/webtech/101399-1.shtml

or

http://www.4guysfromrolla.com/webtech/012101-1.shtml

You may bookmark this site (

http://www.4guysfromrolla.com),

is a great ASP resource.

xcata