DSXchange

I need to write a dos batch file to call a DS job where in the documentation should I look for that code and an example of it?
Jim

Server Job Develper's Guide, DataStage Development Kit (Job Control Interface), Command Line Interface.

dsjob specifically.

Thanx the documentation is so masive its daunting at times
Jim

There are no examples of this and its terably confusing to me,
is it:

dsjob -run -mode[reset] -warn 50 Development Load456msg
?
Jim

Technically, its:

dsjob -server ServerName -user UserName -password Password -run -mode NORMAL ProjectName JobName

You need to supply the values in italics. Being on Windows, you may be able to leave off the userid and password and have it use your current one, I'm not sure. NORMAL is assumed if no mode is passed, or you can RESET or VALIDATE a job instead of running it.

Note that this assumes no Job Parameters are being passed in. To do that, add as many 'name=value' pairs as you need, using "-param ParameterName=Value" syntax for each one. Insert these in the command line before your ProjectName and JobName. You can also slide in a "-warn" and a "-rows" if you like, much like in your example.

You can also add in one of the following - "-wait", "-jobstatus" or "-userstatus" to have the command wait for the job to finish before moving on and to pass back an exit status to the caller. Check the docs for the differences between the three.

when im at a dos prompt, how do I call this? when i put in dsjob even when im in the ascential\datastage\engin folder dos tells me its not a recognized command
Jim

You have to run this on your server machine.

If your DataStage server is a Windows box, you need to include the Ascential paths (do a search for dsjob.exe and include that in the paths).

-T.J.

ya thats where i was on my server in the ascential\datastage\engine dir and i typed in dsjob.exe and it told me that it wasnt a good command. Ill try again in the morning.
Jim

JDionne wrote:ya thats where i was on my server in the ascential\datastage\engine dir and i typed in dsjob.exe and it told me that it wasnt a good command.

On the UNIX side, it lives under the Engine in the "bin" directory... I'm guessing it's the same for Windows.

Typing in partial dsjob commands yields syntax (usage) summaries.

For example (once the DS Engine bin directory is in your PATH), try:

Once u r in bin dir under DSEngine use the command
dsjob -run -param <parameters list> -jobstatus <project name> <Jobname>

Regards,
Praj

Hi,
Just wanted to point out that you can do this on any pc even with no DS client installed, as long as you put the dsjob.exe and several dll's on that pc and it work's like a charm (especially for 3rd party usage - if you don't write a dll of your own for 3rd party applications, be it a regular C/C++ dll or a com dll)

if you still have problems tell us.

IHTH

OK I found the dsjob.exe file right were you guys said it would be. I have taken the sample code from this post and it errored out saying it didnt understand the switches. This is what my code looks like
dsjob -server scrbbususcnc04 -user webi -password 29DmJj13 -mode NORMAL Development Load456msg

isnt there suposed to be a -run in this some were?
Jim

found it
dsjob -server scrbbususcnc04 -user webi -password 29DmJj13 -run -mode NORMAL Development Load456msg

thanx guys
Jim

Sorry, that was my fault. I left it out of my original post, I'll go back and correct it in case anybody else stumbles across it.