Solved

Cmdexec, SQL7 job scheduler and VB6 app

Posted on 2002-05-09
10
343 Views
Last Modified: 2006-11-17
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
Comment
Question by:ddalebout
10 Comments
 
LVL 7

Expert Comment

by:SQL_Stu
Comment Utility
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
 

Author Comment

by:ddalebout
Comment Utility
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
 
LVL 7

Expert Comment

by:SQL_Stu
Comment Utility
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
 

Author Comment

by:ddalebout
Comment Utility
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
 

Author Comment

by:ddalebout
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 7

Expert Comment

by:SQL_Stu
Comment Utility
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
 

Author Comment

by:ddalebout
Comment Utility
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
 

Author Comment

by:ddalebout
Comment Utility
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
 

Expert Comment

by:CleanupPing
Comment Utility
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
 

Accepted Solution

by:
modulo earned 0 total points
Comment Utility
PAQ'd and points refunded

modulo

Community Support Moderator
Experts Exchange
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now