Get metadata info of a SAS DI Studio Job (jobs & tables)

[Billybob73]

Hi,

Does anyone know how you can make a listing of jobs and tables used in those jobs ?

I've come across code to list all libraries and tables, but what I would like to find out is how I can get metadata for a SAS DI Studio job along with the tables used inside that job.

Thanks !

Rgds 

BB

[LinusH]

This will give you a list of metadata objects:

https://documentation.sas.com/doc/en/bicdc/9.4/bisag/n1wwbahzhbhh6gn170r8ei6cklmk.htm

And this can give you relationships between objects:

https://documentation.sas.com/doc/en/bicdc/9.4/bisag/p1dcleibglhr6wn19yzvfz81yw5y.htm

[AllanBowe]

The Data Lineage feature in Data Controller uses proc metatada to get a full mapping of all source / target tables for each job, as described here. 

It's free for 5 users, just get in touch via the website if you'd like to give it a whirl.  It also provides lineage diagrams that link through to the job metadata (using an in-built metabrowse feature).