I have a job that I want to run nightly to update several records in the database. I have an asp script that is fairly complicated, that I want to use and have setup the job to open that page each night at midnight.
The job seems to run fine, but the asp doesn't seem to execute properly. When I go directly to the page it executes just fine and makes the expected changes.
Is there something that would prevent my SQL server from opening up an ASP page and processing the scripts correctly?
Below is the code I'm using as an ActiveX step.
Set WshShell =CreateObject("WScript.Shell")
Set WsShell = Nothing