Getting the job properties using the sql on file system.

ankur.lodha · Post by **ankur.lodha** » Fri Jul 07, 2006 5:18 am

I have a quire to get the all the hash file used in the jobs.

SELECT CATEGORY AS CATGRY, DS_JOBS.NAME AS JOB_NAME ,EVAL DS_JOBOBJECTS.'@RECORD<6>' COL.HDG 'LINK_NAME' ,'File Created in this Job ' AS FILE_TYPE FROM DS_JOBOBJECTS, DS_JOBS WHERE DS_JOBOBJECTS.OBJIDNO=DS_JOBS.JOBNO AND DS_JOBOBJECTS.OLETYPE = 'CHashedInput'

This will give me all the hash file created in the jobs for all the categories .

Similarly I am looking for a record, using which I can retrieve the source table name in the DRS for a particular job.

Is these records well documented somewhere.

Plz help.
:?:

ray.wurlod · Post by **ray.wurlod** » Fri Jul 07, 2006 6:04 am

Welcome aboard. :D

The full structure of the Repository tables is (deliberately, by the vendor) not documented.

kduke · Post by **kduke** » Fri Jul 07, 2006 6:56 am

http://www.dsxchange.com/viewtopic.php?t=93363&start=0 will show you the SQL. You need to add CATEGORY to this.