I have a vbs which pick data from a AS400 server and puts in sql server.I tried to schedule this .vbs file but it does not work. At the scheduled time, the .vbs program get opened in Interdev.

Is there any specific script that have to be written to schedule a vbs file.When i try to use the same code and run it using asp, it works. Please help me out with this.

Perhaps if you change the application associated with .vbs files from InterDev to ComSpec (cmd.exe)



mmcdonal

In my firm we are restricted to use only interdev. When i have to schedule this script on the server, and i guess its the problem with the settings. In the server we have to do some changes in the registery settings. could you please help me out with it. Do we have to use some cscript??

I am not sure why you can only use InterDev to run a script that won't work unless you run it using WScript or CScript or asp.

If you are trying to move files from one server to another, why don't you schedule a DTS package from the SQL Server? Or run the script from a workstation? I use scripts that run from workstations and send workstation data to a SQL server. You could just as easily pull data from the AS400 and send it to SQL. But a DTS package scheduled on the SQL Server is probably a better way to solve this.


mmcdonal

I have successfully scheduled the .vbs file, i tried scheduling it on the server and it works, but at the same time if i schedule it on my PC it dont work properly. what could be the problem? I had read that a .vbs file should always be scheduled on a domain machine.