Hi !
We have multiple projects on the Datastage server and we have access to all the projects.
There is a need to get have a list of all jobs that run each day, when they run the duration of execution. I've looked in the director and manager tools and it seems that this information is available on a project by project basis, but I could not find a way to consolidate all the data into a single report.
Can you let me know if I can get this information in any fashion.
Regards
Nagesh
Details of all jobs running in various projects
Moderators: chulett, rschirm, roy
Details of all jobs running in various projects
Simplicity is the ultimate sophistication
Usiing dsjob comand, and by passing necessary parameters, you can fetch the number of projects available in the server. And by using the same dsjob and passing by different parametet, you can find the list of jobs available the project, and the respective time of finish can be found.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are no global tools; everything is unique to its own project. You could, of course, wrap per-project information gathering into a consolidated report using your own utility, be it a shell script or some kind of DataStage API utility.
Hey, looks so simple!
Code: Select all
Foreach project
Foreach job in project
Foreach invocation of that job
If job ran today
Obtain statisitics
Write to file/table
EndIf
End Foreach
End Foreach
End Foreach
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.