process metadata

mcs_suman · Post by **mcs_suman** » Sun Aug 03, 2008 7:49 am

HI friends,

our job is to generate process meta data ,to get job log in to file we did this with after job subroutine option dsjobreport and got the output generated. is there any other possible ways to do this.

chulett · Post by **chulett** » Sun Aug 03, 2008 7:55 am

Sure, but they're all variations on that theme.

ray.wurlod · Post by **ray.wurlod** » Sun Aug 03, 2008 7:56 am

Several. One is to purchase MetaStage, which allows you to capture process metadata automatically. Another is to write routines using the DataStage API, whether in the DataStage BASIC language or in the C language. The DataStage C-callable API is documented in the Server Job Developer's Guide and in the Parallel Job Advanced Developer's Guide. You could also download ETLstats from Kim Duke's website in which all the work has already been done for you (however, if you were to re-deploy this for profit there are likely to be licensing issues).