list project\jobs from clientside - dsjob.exe
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 35
- Joined: Thu Apr 19, 2007 12:42 pm
list project\jobs from clientside - dsjob.exe
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?
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
The dsjob.exe should exist on your Windows client as well. I found it in the same location as the Client software itself:
HOpe this helps.
Brad.
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
Brad.
It is not that I am addicted to coffee, it's just that I need it to survive.
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. ![Confused :?](./images/smilies/icon_confused.gif)
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.
![Confused :?](./images/smilies/icon_confused.gif)
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
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;
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?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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA