how to read the job log and to capture the statistics
like datastage job name,start time,end time ,project, duration,sucess etc
To capture job statistics
Moderators: chulett, rschirm, roy
Re: To capture job statistics
You can also use the "dsjob -report" command ( check the Advanced Developer's Guide for a list of all available options ).parsi_cnu wrote:how to read the job log and to capture the statistics
like datastage job name,start time,end time ,project, duration,sucess etc
I do prefer to use the XML option because it can easily be formated in HTML and that option lets you have the most detailed informations ( like PID of processes, calculated CPU time... ).
Regards,
Daniel
Daniel
The main job in EtlStats uses dsjob -report XML to load these stats into tables. The DDL for ETL_JOB_HIST, ETL_ROW_HIST and ETL_PARAM_HIST is included in the zip file. The bugs in XML forced me to process the XML file 3 times. This main job is called DSJobReportDb.
If you call job DSJobReportDbDriver at the end of your sequences then it will get your row counts for all jobs in this sequence. It will call EtlChkSeqJobsNotRun and email you the log in an html attachment of all jobs which failed.
You get the source code to every job and sequence to you can modify to meet your needs.
If you call job DSJobReportDbDriver at the end of your sequences then it will get your row counts for all jobs in this sequence. It will call EtlChkSeqJobsNotRun and email you the log in an html attachment of all jobs which failed.
You get the source code to every job and sequence to you can modify to meet your needs.
Mamu Kim