Have anyone out there created a server job to populate a tab

4friends · Post by **4friends** » Tue Dec 11, 2007 11:17 pm

HI All,

Have anyone out there created a server job to populate a table with all the available job properties such as Job Status, Number of Rows etc.

I want to add this job to all the sequence jobs - right at the end.

Thanks in Advance.

kduke · Post by **kduke** » Tue Dec 11, 2007 11:27 pm

Do a search on EtlStats.

4friends · Post by **4friends** » Tue Dec 11, 2007 11:32 pm

Hi Duke,

Wat is Etlststs

manjunathnet · Post by **manjunathnet** » Wed Dec 12, 2007 12:27 am

if u want send all the information about job status, then u can use dsjob -logsum in excute command and write it to a file, then next pass file as job status.
This will gives all information as like in director log.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 12, 2007 1:23 am

U is a common Burmese name. The second person personal pronoun in English is spelled "you". A wat is a Buddhist temple. The interrogative that you possibly intended to use is spelled "what" in English.

kduke · Post by **kduke** » Wed Dec 12, 2007 7:09 pm

EtlStats is about 40 jobs. One of which is used to gather stats about job runs. It populates 3 tables ETL_JOB_HIST, ETL_ROW_HIST and ETL_PARAM_HIST. It also populates 3 hashed files so you can build your own restartable job logic. There are a whole bunch of other jobs which help extract metadata from DataStage's repository.

kduke · Post by **kduke** » Wed Dec 12, 2007 7:10 pm

By the way it is a free download from my tips page below my signature.