I wrote a VB6 executable to run at night to handle Data Imports into SQL 2000. I scheduled this in SQL 2000 to run as a Job. It keeps on Failing. I Tell the Scheduler it is a CMDEXEC (Operating System Command) and I place the full path in the Command Textbox. When it is suppose to start running it shows the process started in the Task Manager, but the form I designed does not show, and the process hangs. Does the Scheduler not handle executables too well?
I can’t find any guidance or sample code for this anywhere. Al samples simple schedule Stored Procs to run.
Any help will be appreciated
Regds
Len