crystaltec
asked on
ASP Trigger for time based event
Hi,
Running classic ASP with Sql Server (sql version), I need to find a solution for triggering a time-based event in this stateless environment. Surely there must be some way to do this. Eg I need a way to trigger a function in classic ASP code that imports data from an external txt file into SQL server table. This even needs to run at five in the morning every day.
If not classic ASP, then how is it done in .NET? We could turn on .NET for that purpose alone.
Thanks for any help...
Running classic ASP with Sql Server (sql version), I need to find a solution for triggering a time-based event in this stateless environment. Surely there must be some way to do this. Eg I need a way to trigger a function in classic ASP code that imports data from an external txt file into SQL server table. This even needs to run at five in the morning every day.
If not classic ASP, then how is it done in .NET? We could turn on .NET for that purpose alone.
Thanks for any help...
You simply need to run a scheduled task. Do you have access to the task scheduler or are you on a shared host? Some shared hosts will have a way for you to schedule a task. You can have the task scheduler hit your asp page or just make it a vb or vbs.
ASKER
I have full access to the host. So the scheduled task would literally open a page on my site?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Seems to work perfectly.
Thanks!
Thanks!