Convert vbscript wab page to run as scheduled task on a server

[teecee99]

This may be a dumb question but here goes.

I have a retail web-site and back end order processing system built with vbscript that is currently hosted on GoDaddy on a shared hosting platform (i.e. I have no access to server based schedulers).

We are about to move to a dedicated server so I can now schedule "server" processes.

We have a number of ".asp" pages that perform tasks such as tidying up the database that right now we run by hand.

Is there any way to set-up a "server" based task that goes to a specific URL? It would need to login to the page automatically.

Alterntively is there a way to take the VBscript out of the .asp page and convert it to VisualBasic (or some other language) that would create an executeable file on my Windows 2003 server?

I have seen some posts that talk about converting vbscript to other web page scripting language but nothing that talks about converting to server side executeable code.

Thanks for any advice!

[markrawlingson]

I don't know about executable; my knowledge of Visual Basic application programming is limited. Recently, I was able to convert a 30kb list of functions developed in ASP to a registerable .dll file with Visual Basic though, that's pretty close - so i'd venture a guess at yes, especially since vbscript/asp is just a run down version of VB. As long as you add in all the necessary references etc.

It sounds like you're trying to run a windows based CRON job, am I right? You want to automatically execute a script at a specified interval.. everyday, every hour, every 5 minutes, or whatever...?

If that's the case, I did stumble across a page a while back that explained how to do this with window scheduler, I found it interesting so I bookmarked it.

Check it out, might be a good solution for you if that's what you're trying to do.

http://drupal.org/node/31506

I must point out, though, that i have never used this or even tested it.

Hope that helps.
Sincerely,
Mark

[CroCrew]

Hello teecee99,

markrawlingson is right, as soon as you get your server you will want to look in to making a “Windows Server Service” and is easily done with Visual Studio.

What type of database are you using? If your database environment allows the use of Stored Procedures and or Triggers then you could use them. They are powerful tools in keeping databases regular. Many time under used to people that have access to use them.

Check out if you have the ability to use them and if you do; learn more about them. You just might find that you can simplify your role as database administrator when using them.

Hope all works out for ya~