DTS with Execute Process task not running when scheduled in the agent

Question

DTS with Execute Process task not running when scheduled in the agent

joy_arcinas

SSC Veteran

Points: 248
More actions
November 6, 2007 at 3:57 pm

#183798

Hi
Just trying to get some help.
I made a DTS that runs an executable(say notepad.exe) thats all there is in the DTS.
It runs on the Enterprise Manager but If I scheduled it doesnt seem to finish executing it.
The sql server agent account is on system and the package is owned by a user which is an administrator.
The status of the job will always say "Executing job step..." and doesnt seem to run or complete it.
Thanks for the ideas in advance.
Joy

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jez-448386 SSCarpal Tunnel Points: 4596 More actions · Answer 1

I created a DTS package that opened notepad and the package only completed when I closed notepad. Is this the same as your situation?

If so then when you schedule the package it will open a notepad session and wait for it to close. However, the notepad session will run in the same mode as the scheduler i.e. as a service and will not be visible - if you look in task manager on the server you will see a notepad task running and you will have to kill the task.

The execute process task will start an external task and wait for it to finish. I suspect that notepad is not what you really want to do, just a test. What are you trying to run externally?

Jez

Loner SSC-Insane Points: 21279 More actions · Answer 2

The problem is when you execute notepad.exe using Execute task and runs on a job. You need to put the directory, otherwise, it does not know where to find the exe.

joy_arcinas SSC Veteran Points: 248 More actions · Answer 3

thanks for the replies,

notepad is just an example. but even if its just a batch file that do some task, it doesnt seem to run it.

it does appear on the task manager but its not really executing the task.

any other ID's

thanks.

Jez-448386 SSCarpal Tunnel Points: 4596 More actions · Answer 4

Does the batch job run correctly? Can you execute the batch job from a dos window/command line? If there are any problems and it reports an error it may be waiting for a reponse from you - but as it is running as a service you will not see the prompt. I had similar problems with WinZip a few years ago and had to get the command line addin so that it would not pop up a window when there was a problem.

Jez