Details of all jobs running in various projects

srinagesh · Post by **srinagesh** » Fri Sep 15, 2006 7:50 am

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

Woth · Post by **Woth** » Fri Sep 15, 2006 9:12 am

Looks like API functions could help you there [Server job Developer's Guide].

Here are some of the functions you could use....

DSGetProjectList
DSOpenProject
DSGetProjectInfo
DSGetJobInfo

hope it pushed you in the right direction

kumar_s · Post by **kumar_s** » Fri Sep 15, 2006 9:13 am

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.

kduke · Post by **kduke** » Fri Sep 15, 2006 1:25 pm

I would start with

ps -ef | grep phantom

Now the problem is what project do these jobs belong to.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 15, 2006 5:59 pm

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.

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

Hey, looks so simple!