topic Re: update control table information in Administration and Deployment

update control table information

chirumalla — Thu, 23 Jan 2014 02:44:23 GMT

Hi,

In DI studio Jobs development I need to populate one control table(For client view) having below info how can I get this info through status handling or need to write any post code advise me.

if code pls give me some sample code.

*Job name*	*Library*	*Job start time*	*Job end time*	*No. Records before*	*No. Records after*	*Table name*	*Job return code*

Re: update control table information

LinusH — Thu, 23 Jan 2014 07:45:24 GMT

Some of the you could get through macro variables created automatically by DIS, such as rc, job name, start and end time.

Records before/after you probably need some PROC CONTENTS/SASHELP.VTABLE query.

I recommend that you carefully examine the code generated by DI Studio, and then try to a programming effort. Please get back if you any specific problem arises.

Re: update control table information

pradeepalankar — Thu, 23 Jan 2014 08:14:26 GMT

if you are using DI studio then these can be automatically collected by just enabling Status handling property of DI studio there is no need to write any manual code any where in the job.

job properties>status handling tab>new job condition > choose send job status

then provide output dataset where these results will be accumulated.

Re: update control table information

chirumalla — Tue, 28 Jan 2014 14:19:45 GMT

Hi Pradeep,

Thanks for your answer, as you suggested I given job level but the client asking flow level statistics in one table. LSF is capable to produce flow statics if pls advise me.