DSXchange

Posted: **Mon Jan 12, 2009 12:35 pm**

I am trying to implement Kim D. script to export job HTML reports but cannot located the dsjob.exe. The only existence of the script is on the AIX DataStage server. Am I missing something? Is their a way to export this information from the client?

Posted: **Mon Jan 12, 2009 12:48 pm**

As this is server-side functionality, you'd need to get your hands on the executable from someone who has a Windows version of the DataStage server. From what I recall, the actual dirty-work is done using "dsdesign.exe" which you'll have, the rub is getting the list of jobs to iterate through. Perhaps generate that list over on the server side and then ftp it to your client PC?

Posted: **Mon Jan 12, 2009 1:59 pm**

On UNIX platforms there is no ".exe" suffix. The dsjob executable is to be found in the DataStage engine's bin directory. Your command search list (the PATH environment variable) apparently does not include this directory.

Posted: **Wed Jan 14, 2009 5:33 pm**

The dsjob.exe should exist on your Windows client as well. I found it in the same location as the Client software itself:

Code: Select all

C:\Program Files\Ascential\DataStage7.5.2>dir ds*.exe
DSDesign.exe     dscmdexport.exe  dsimport.exe     dssearch.exe
dsadmin.exe      dscmdimport.exe  dsjcwiz.exe      dsviewer.exe
dscc.exe         dsexport.exe     dsjob.exe

C:\Program Files\Ascential\DataStage7.5.2>dsjob.exe
Command Syntax:
        dsjob [-file <file> <server> | [-server <server>][-user <user>][-passwor
d <password>]]
                        <primary command> [<arguments>]

Valid primary command options are:
        -run
        -stop
        -lprojects
        -ljobs
        -linvocations
        -lstages
        -llinks
        -projectinfo
        -jobinfo
        -stageinfo
        -linkinfo
        -lparams
        -paraminfo
        -log
        -logsum
        -logdetail
        -lognewest
        -report
        -jobid

HOpe this helps.

Brad.

Posted: **Wed Jan 14, 2009 6:04 pm**

I wonder what in the heck I was thinking of. I distinctly remember having to 'borrow' something from another colleague who's server was on Windows, I'll need to go back thru my email archives.

I'm wondering if I'm thinking of older versions of the client, 6.x perhaps. I believe the inclusion of dsjob executable with the client software is a fairly "recent" event. But that does mean the OP should be able to find it on their PC.

Posted: **Thu Jan 15, 2009 6:56 am**

I happened to be doing a little light reading yesterday and came across this in the client readme of our 7.5.2 Windows Client install;

DSjob is now installed with DS client installation
--------------------------------------------------
The dsjob command-line utility is now installed as part of the DS client
installation. This will enable customers in Unix server environments to
control jobs from Windows DS client machines.

But how would a UNIX Server install control a job from a Windows client via dsjob on the command line? How would it find the Server, Project and job?

Posted: **Thu Jan 15, 2009 8:26 am**

You'd have to fully spell that out on the command line - server, user, password, etc. or take advantage of the -file option. Come to think of it, I don't believe I've ever actually tried to run a job from my PC but have scripted it into things to list project and job names, for instance.

Posted: **Thu Jan 15, 2009 8:42 am**

-run works no problem. I forgot about the server credentials. Thanks.

DSXchange

list project\jobs from clientside - dsjob.exe

list project\jobs from clientside - dsjob.exe