Execute DSJOB Command Remotely

dec1177 · Post by **dec1177** » Wed Jul 23, 2008 3:37 pm

Hello.

I have a very simple .bat file with the following DOS commands:

@ECHO OFF
dsjob -server myServerName -user myUserName -password myPassword -run myProjectname myJobName
CLS
EXIT

When I execute this .bat file on the ETL server via a Remote Desktop Connection, the .bat file executes successfully. However, if I attempt to execute the .bat file from my Desktop that's on the same network, nothing happens. After reading the Server Job Developer's Guide page 19-140, I was lead to believe I could execute a DSJOB command from a remote computer on the network...is this not the case? What am I missing?

Any help is much appreciated.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 23, 2008 5:08 pm

Be more precise about "not working". What error code/message do you get?

dec1177 · Post by **dec1177** » Thu Jul 24, 2008 8:53 am

Ray,

Thanks for the response. I modified the .bat file a bit so that it would echo the command and pause so I could see the resulting message. The message is as follows:

"'dsjob' is not recognized as an internal or external command, operable program or batch file."

Does this mean the dsjob.exe has to be present on both computers on the network?

ArndW · Post by **ArndW** » Thu Jul 24, 2008 9:01 am

This means it couldn't find your local "dsjob.exe" on your PC. You will need to add your dsjob.exe to your PC environment's path or explicitly code the location into your .bat program.

dec1177 · Post by **dec1177** » Thu Jul 24, 2008 9:39 am

Thanks ArndW. Explicitly coding the location of my local dsjob.exe did the trick. As a helpful tip for anyone else that may come across this issue, this is exactly what my dsjob command line looks like now:

"C:\Program Files\Ascential\DataStage7.5.2\dsjob" -server myServerName -user myUsername -password myPassword -run myProject myJobName

I had to include the path in quotes because of the fact there's a space in the pathname (I think). The .bat file executes perfectly now.

chulett · Post by **chulett** » Thu Jul 24, 2008 9:43 am

dec1177 wrote:I had to include the path in quotes because of the fact there's a space in the pathname (I think).

Yup. Thank you Windows "long filenames".

Or you could have used the original recipe 8.3 "short" name without quotes, which is (more than likely) "Progra~1".

dec1177 · Post by **dec1177** » Thu Jul 24, 2008 9:53 am

Absolutely right. Using:

C:\Progra~1\Ascential\DataStage7.5.2\dsjob ....etc.

(without the quotes) works as well.

Thanks again.