Page 1 of 1
How to know the update date and time of a source
Posted: Thu May 29, 2008 9:47 am
by gpbarsky
Hi, my friends....
I'm looking a way to know each job modification date (server or sequencer).
If I compile the job today, I can see that the Date/Time modified (within Manager) is set to today date.
Is there a way to get the real job update date and time ?
Thanks in advance.
Posted: Thu May 29, 2008 11:31 am
by chulett
'Real' job update date/time? Depending on what that means, you could query the DS_AUDIT table in the repository for that I would think.
Re: How to know the update date and time of a source
Posted: Fri May 30, 2008 12:43 am
by ag_ram
gpbarsky wrote:Hi, my friends....
I'm looking a way to know each job modification date (server or sequencer).
If I compile the job today, I can see that the Date/Time modified (within Manager) is set to today date.
Is there a way to get the real job update date and time ?
What you need exactly?
Job Modification TimeStamp or Job Compilation TimeStamp
Job Modification TimeStamp - DS_AUDIT
Job Compilation TimeStamp - RT_CONFIGnnn(31th Field, in DataStage internal format)
Re: How to know the update date and time of a source
Posted: Fri May 30, 2008 12:43 am
by ag_ram
gpbarsky wrote:Hi, my friends....
I'm looking a way to know each job modification date (server or sequencer).
If I compile the job today, I can see that the Date/Time modified (within Manager) is set to today date.
Is there a way to get the real job update date and time ?
What you need exactly?
Job Modification TimeStamp or Job Compilation TimeStamp
Job Modification TimeStamp - DS_AUDIT
Job Compilation TimeStamp - RT_CONFIGnnn(31st Field, in DataStage internal format)
Posted: Fri May 30, 2008 8:07 am
by gpbarsky
Thanks, Ram and Craig.
Do you know the format of the DS_AUDIT table ?
Posted: Fri May 30, 2008 8:26 am
by chulett
It's not in the public domain, but you can do a 'LIST.DICT' on it or just a 'select * from' and see what you get.
Posted: Fri May 30, 2008 9:12 am
by gpbarsky
Thank you very much, Craig.
I'll try to develop the DS job to list the DS_AUDIT table. I know that this is not an easy task, but I will try.
Posted: Fri May 30, 2008 9:25 am
by chulett
You could also do a 'LIST.DICT DS_AUDIT' from the Administrator client. Search the forums for COMO to find ways to get that output in a file.
Posted: Fri May 30, 2008 3:45 pm
by ray.wurlod
Tip: create/import a table definition with "metadata supports multi-valued fields" check box checked. Then use a UniVerse stage to extract from DS_AUDIT. Use two output links, one un-normalized and the other normalized on MODS.