list project\jobs from clientside - dsjob.exe

[dav_mcnair]

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?

[chulett]

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?

[ray.wurlod]

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.

[bcarlson]

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.

[chulett]

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.

[throbinson]

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?

[chulett]

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.

[throbinson]

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