I would like to create 2 tables:
The first 1 I can do. I send the job status to a table, no issues there.
2: You know when a job completes in DI Studio the statistics tab is populated? Well, I want those results available in a table. In particular, I'd like to have 1 table where all my results are appended to ( I may run into an issue when jobs are run at the same time but I'll cross that bridge when I come to it). I want this table so that I may code some conditional logic around it and display the results in our Portal.
So is there an easy way to parse the log file? I saw "some" SAS examples where they help you parse general logs but I would much rather let DI Studios and ARM handle this for me. Then, I would register the output table in metadata and be on my way.
2. DI Studio job statistics in 9.2 use ARM technology which is an industry standard technique for capturing performance information. You can configure additional appenders for ARM to write the DI Studio performance metrics and other content out to tables such as database tables. There is information on how to configure ARM appenders and details about the ARM infrastructure available in SAS 9.2 here: http://support.sas.com/documentation/cdl/en/armref/61526/HTML/default/viewer.htm#titlepage.htm