Getting the job properties using the sql on file system.
Posted: 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.
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.