?
Solved

Cmdexec, SQL7 job scheduler and VB6 app

Posted on 2002-05-09
10
Medium Priority
?
352 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 7

Expert Comment

by:SQL_Stu
ID: 6998701
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
ID: 6998722
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
ID: 6998744
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
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 

Author Comment

by:ddalebout
ID: 6998751
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
ID: 6998857
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
 
LVL 7

Expert Comment

by:SQL_Stu
ID: 6998880
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
ID: 6998888
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
ID: 6998894
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
ID: 9280527
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
ID: 9620286
PAQ'd and points refunded

modulo

Community Support Moderator
Experts Exchange
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

649 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