I have created and compiled a VB 6 executable file. Now, I just want to run it at a specified time from within a SQL Server 7 Job.
The executable file can be run from a command prompt, but if I create a job in SQL Server and set the job step to a type of CmdExec, the step acts as if it can't find the executable. I even typed the full path name in the step.
Has anyone else encountered this problem?