[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

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
0
ddalebout
Asked:
ddalebout
1 Solution
 
SQL_StuCommented:
Have you made sure that you are running the app on the server?

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.
0
 
ddaleboutAuthor Commented:
Hi
The app is on the server and I want it to execute on the server. It runs from the server's D drive
0
 
SQL_StuCommented:
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?
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
ddaleboutAuthor Commented:
Hi
The app is on the server and I want it to execute on the server. It runs from the server's D drive
0
 
ddaleboutAuthor Commented:
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
0
 
SQL_StuCommented:
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)

0
 
ddaleboutAuthor Commented:
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
0
 
ddaleboutAuthor Commented:
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
0
 
CleanupPingCommented:
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.
0
 
moduloCommented:
PAQ'd and points refunded

modulo

Community Support Moderator
Experts Exchange
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now