Scheduling an event to run on the web server

[bdwest]

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

[bruce]

Brian,

As of currently, we do not allowed scheduled tasks. This feature is already on the list of feature we want to add. You will receive an email when this feature is available.

[b]quote:Originally posted by bdwest

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
</blockquote id="quote"></font id="quote">

[CreativeLightning]

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

[bruce]

Probably sometime in the 4th quarter.


[b]quote:Originally posted by homeacademy

I'd really like to see this feature. Any updates you can share?
</blockquote id="quote"></font id="quote">

[homeacademy]

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

[homeacademy]

Thanks.

[homeacademy]

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...

[homeacademy]

[b]

[bruce]

The preliminary spec

- free feature
- run every 15 minutes


[b]quote:Originally posted by homeacademy

[b]
</blockquote id="quote"></font id="quote">

[homeacademy]

Looks like that will work great for me! Thanks!

[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


[b]quote:Originally posted by bruce

The preliminary spec

- free feature
- run every 15 minutes


[b]quote:Originally posted by homeacademy

[b]
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

[bruce]

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

[b]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


[b]quote:Originally posted by bruce

The preliminary spec

- free feature
- run every 15 minutes


[b]quote:Originally posted by homeacademy

[b]
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

[bebemau]

[b]quote:Originally posted by bruce

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

[b]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


[b]quote:Originally posted by bruce

The preliminary spec

- free feature
- run every 15 minutes


[b]quote:Originally posted by homeacademy

[b]
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

[bebemau]

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

I think we need an edit button for our posts.

[bebemau]

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?

[bruce]

You should see an button above the message with a pencil on it. that's the edit button

[b]quote:Originally posted by bebemau

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

I think we need an edit button for our posts.
</blockquote id="quote"></font id="quote">

[bruce]

We'll provide a interface in the CP

[b]quote:Originally posted by bebemau

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?
</blockquote id="quote"></font id="quote">

[homeacademy]

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

[b]quote:Originally posted by bruce

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

[Eric]

Sometime Q1 2004. Please stay tuned for announcments.

[homeacademy]

Thanks! I'll be watching [8D]