Job Report Through Unix - Including File Paths

altruist · Post by **altruist** » Sat Jul 27, 2013 1:14 am

Hi,

I wanted to kick off a script, which can fetch me ALL the job details eg. Job Description, File Paths etc. similar to File Menu > Generate Report.

I have checked dsjob -report , but it doesn't fetch all the details as listed above.

ray.wurlod · Post by **ray.wurlod** » Sat Jul 27, 2013 2:04 am

Sounds like you need to create your own script, then.

altruist · Post by **altruist** » Sat Jul 27, 2013 8:56 am

Hi Ray,

Can you please let me know where I can get the information to write the shell script. I basically want to search for any string pattern in the entire project.

Are there any UV tables where I can get ALL the information pertaining to job.

ray.wurlod · Post by **ray.wurlod** » Sat Jul 27, 2013 3:49 pm

All of the design-time information can be had from DS_JOBOBJECTS table. Much of the information about relationships between stages is also to be found in the RT_CONFIGnnn table for the job, while the run-time status is to had from the RT_STATUSnnn table.

However the structure of these tables is not documented by the vendor, and the right to change them at any time is reserved.