SQL Server Jobs

[tazman]

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?

[Clunietp]

I don't have an answer, but a possible workaround:

Can you use the Windows Task Scheduler/AT Service to launch your EXE?

[tasmisr]

did u find an answer?

[vb_dba]

What does your job step look like? You could try running xp_cmdshell ('c:\AppPath\app.exe'). This will/should work as long as you app doesn't have any forms that are displayed to the screen.

[tasmisr]

xp_cmdshell would run syncronously and hang the stored procedure or job,,,,even If I don't have a UI displayed....
I ended up using the AT scheduler..hopefuly it's gonna work while I'm logged of!!