ddalebout
asked on
Cmdexec, SQL7 job scheduler and VB6 app
Hi
I'm trying to automate a VB6 program using SQL7's job Scheduler. The problem is that the Scheduler keeps saying executing job but it doesn't really run the vb6 app
What am I doing wrong ?
Deon
I'm trying to automate a VB6 program using SQL7's job Scheduler. The problem is that the Scheduler keeps saying executing job but it doesn't really run the vb6 app
What am I doing wrong ?
Deon
ASKER
Hi
The app is on the server and I want it to execute on the server. It runs from the server's D drive
The app is on the server and I want it to execute on the server. It runs from the server's D drive
Are you absolutely sure that the app isn't running? How do you know?
Does the SQL account that is running the server have NT security to the app location?
Does the SQL account that is running the server have NT security to the app location?
ASKER
Hi
The app is on the server and I want it to execute on the server. It runs from the server's D drive
The app is on the server and I want it to execute on the server. It runs from the server's D drive
ASKER
Hi
Yes the apps is not running -checked in task manager-
Yes it does have access to the directory. If I run the app in a dos box on the server it works
Yes the apps is not running -checked in task manager-
Yes it does have access to the directory. If I run the app in a dos box on the server it works
Have you checked the job history to see what was recorded after it ran?
Also, are you aware that to run a DOS app, you must use 8-character file names? (ie. C:\Program Files becomes C:\Progra~1)
Also, are you aware that to run a DOS app, you must use 8-character file names? (ie. C:\Program Files becomes C:\Progra~1)
ASKER
Hi
Yes the apps is not running -checked in task manager-
Yes it does have access to the directory. If I run the app in a dos box on the server it works
Yes the apps is not running -checked in task manager-
Yes it does have access to the directory. If I run the app in a dos box on the server it works
ASKER
Yes , Scheduler says the job is executing and keeps saying thatuntil I cancel the job after 3 hours ( it should take 3 minutes)thus all I can see in job history is a cancelled job
ddalebout:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Whenever you run a job in the scheduler, all commands are run on the server, not on the machine you start the job from. Therefore, if your app is called XXX.EXE and it is located on your local machine, the server won't be able to run the app.