universe table / hash file for the final status of job

sonia jacob · Post by **sonia jacob** » Wed Dec 15, 2004 3:14 pm

Hi,

I would like to know the universe table/hash file and its definition that would give me the final status of the job, the same info that the DSGetJobInfo would give me for the following Info types; DSJ.JOBSTATUS, DSJ.JOBSTARTTIMESTAMP, DSJ.JOBLASTTIMESTAMP.
Is it RT_STATUSnn?

thanks

roy · Post by **roy** » Wed Dec 15, 2004 3:22 pm

Hi,
when you'll know this what do you want to do with this info?
what will happen when a new version comes out and this info is no longer correct?
DSGetJobInfo will be maintained for you but not your own custom design.

if you insist you can always put a trace and hack it thru but I'm not all for this aproach.

so post your need/what you want to acomplish and hopefully some of us might have something for you.

IHTH,

sonia jacob · Post by **sonia jacob** » Wed Dec 15, 2004 3:43 pm

roy wrote:Hi,
when you'll know this what do you want to do with this info?
what will happen when a new version comes out and this info is no longer correct?
DSGetJobInfo will be maintained for you but not your own custom design.

if you insist you can always put a trace and hack it thru but I'm not all for this aproach.

so post your need/what you want to acomplish and hopefully some of us might have something for you.

IHTH,

I had written a routine (thanks to kim) to read the RT_LOGnn file to get the LOG details on the latest run. I use this info to create a LOG file of a different format with the just the warnings and the fatal errors.

So to improvise on this routine / the log file created, I though I could give something like a header / summary info for the job. Just a a single line, with the status of the job, start time, endtime and no. of read, loaded and rejected.

DSMakeJobReport does it, but then I would need to create this file, read the file created by this routine, then put the data into my LOG file and then delete the report file.

thanks

ray.wurlod · Post by **ray.wurlod** » Wed Dec 15, 2004 7:29 pm

It IS RT_STATUSnn, but you need to be aware that you also have to consider that there are three different record types in this hashed file, and that you also have to select the correct wave number.

It's not as easy as it first appears.

Also, chances are that it will change markedly in the next (major) release, if the rumours turn out to be correct.

kduke · Post by **kduke** » Wed Dec 15, 2004 8:13 pm

Ray is correct to get it out of this file is not a good idea especially if the job has multiple instances. Just download EtlStats.zip. Much easier.