lil_puffball
asked on
Run ASP file every day at midnight (possibly using cron jobs?)
Hi,
I'd like to be able to run an ASP page every day at midnight. The ASP page basically contains script to update a database. I've never done anything like this before so I'm not sure how to proceed. I did find that cron jobs might be helpful, but I don't know how to use them. Any help is much appreciated, thanks!
I'd like to be able to run an ASP page every day at midnight. The ASP page basically contains script to update a database. I've never done anything like this before so I'm not sure how to proceed. I did find that cron jobs might be helpful, but I don't know how to use them. Any help is much appreciated, thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The Windows Task Scheduler is installed by default on the web server. Whether or not your ISP exposes it through your control panel in another thing...but remember, to run your page it simply needs to be opened in a browser and allowed to complete.
This means you can schedule this from any computer, say some server at your home or office or even from a non windows box, such as a cron job on a *nix machine.
This means you can schedule this from any computer, say some server at your home or office or even from a non windows box, such as a cron job on a *nix machine.
What kind of database are you updating with your asp page? If it is MS SQL Server you would be better off creating a DTS package to do the update.
lil_puffball, has this issue been resolved?
ASKER
Oops, I'm very sorry, I ended up not needing a solution to this after all. I had completely forgot that the question was still open because I was away on vacation for two weeks afterwards.
Since I didn't use any of the solutions but I'm very grateful for all the help, I'll split the points evenly between rdivilbiss and jawahar_prasad. Thanks!
Since I didn't use any of the solutions but I'm very grateful for all the help, I'll split the points evenly between rdivilbiss and jawahar_prasad. Thanks!
ASKER
Sorry, ddrudik, I meant to add you in the last post also. Thanks for being the first to reply and also reminding me that the question was still open! :)
Thanks for the question and the points.
ASKER
Thanks for both replies. However, I need this to work on a website (not just on my own computer). Does that mean I would have to somehow install Windows Scripting Host onto the server which hosts the website? Is this easy to do, or is there possibly a better way?