Page 1 of 1
Have anyone out there created a server job to populate a tab
Posted: Tue Dec 11, 2007 11:17 pm
by 4friends
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.
Posted: Tue Dec 11, 2007 11:27 pm
by kduke
Do a search on EtlStats.
Posted: Tue Dec 11, 2007 11:32 pm
by 4friends
Posted: Wed Dec 12, 2007 12:27 am
by manjunathnet
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.
Posted: Wed Dec 12, 2007 1:23 am
by ray.wurlod
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.
Posted: Wed Dec 12, 2007 7:09 pm
by kduke
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.
Posted: Wed Dec 12, 2007 7:10 pm
by kduke
By the way it is a free download from my tips page below my signature.
