Scheduling an event to run on the web server

I am currently updating an on-line database from another on-line source. Currently the user has to trigger the update event to run. This works fine but I would like to take the user out of the loop. Is there a way to schedule an event to run on the server at specific intervals or times.

Thanks

Brian

 

I'm not sure if you have an extra computer around or mind keeping an extra window open but you can create an asp script to call a procedure or function and use meta refresh set at the interval.

Kind of cheesy but I've done it in the past.

If the information just needs to be updated before someone browses you could timestamp the last update in the database and add the function to your:
Sub Application_Start(aspx global.asax.vb)
or
Sub Application_OnStart(classic asp global.asa)

You could use something similiar to this:
Create a new table with one field (lastupdate datetime)
Use something like this code.

ctime = DatePart(Hour,NOW()) - 4
'Get the data from the last update
If DatePart(Hour,rs("lastupdate")) > ctime Then
'Perform procedure Then update lastupdate field with current time
End If

Every time someone started a session if the database in this example had not update in the last 4 hours it would update then. If you don't have a lot of traffic say normally at least a visitor every few hours you would want to use day comparisons as well.

OR DatePart(Day,rs("lastupdate")) < DatePart(Day,NOW()) Then
'perform update etc....

End of the month consideration:

Or DatePart(Month,rs("lastupdate")) < DatePart(Month,NOW()) Then
'perform update

End of year:

Or DatePart(Year,rs("lastupdate")) < DatePart(Year,NOW()) Then
'perform update

Hope this makes sense.

gninthgiLevitaerC

 

I'd really like to see this feature. Any updates you can share?

 

Thanks.

 

Now that we've started the 4th quarter, any more specifics you can share? How often will we be allowed to have things run? Extra fee involved or with basic hosting? Just wondering...

 

Looks like that will work great for me! Thanks!

 

Hi Bruce,

I am also interested in something like a scheduled task. It is going to be an aspx file that runs every week. Is it something I can setup in control panel?

Thanks


quote:Originally posted by bruce

The preliminary spec

- free feature
- run every 15 minutes


quote:Originally posted by homeacademy


</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

 

quote:Originally posted by bruce

The schedule task tool is plan to go into development in 01.2004

quote:Originally posted by bebemau

Hi Bruce,

I am also interested in something like a scheduled task. It is going to be an aspx file that runs every week. Is it something I can setup in control panel?

Thanks


quote:Originally posted by bruce

The preliminary spec

- free feature
- run every 15 minutes


quote:Originally posted by homeacademy


</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

 

Meant to say thank you... [:I]

I think we need an edit button for our posts.

 

oh, missed that.[8D]

Bruce, one more question in regards to the scheduled task thing. So if it is not a setting we can change in control panel, can we put in a ticket to have it set up?

 

Go in to DEVELOPMENT? So that means you are just going to start coding? Somewhere above, you said something about releasing in the 4th quarter. With all the e-mail and other problems you've been having I completely understand the delay, but can you provide a new estimated release date?

Thanks

quote:Originally posted by bruce

The schedule task tool is plan to go into development in 01.2004
</blockquote id="quote"></font id="quote">

 

Thanks! I'll be watching [8D]