How to get the date of job creation

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

ravij
Premium Member
Premium Member
Posts: 170
Joined: Mon Oct 10, 2005 7:04 am
Location: India

Post by ravij »

Hi Arnd,
I would suggest that you manually enter a fixed-format text that you can parse out of the text, such as "Job Created on yyyy-mm-dd" to store that information.
Do u mean that we should maintain the text files manually?
thanks in advance.
Ravi
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Yes, since in your situation there is no automatic means to do this you need to do it manually.
ravij
Premium Member
Premium Member
Posts: 170
Joined: Mon Oct 10, 2005 7:04 am
Location: India

Post by ravij »

Thanks Arndw
Ravi
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

wahil,

good guess, and it might work most of the but it isn't correct. The DATA.30 and OVER.30 are components of a type 30 hashed file, and if entries are made to the table that cause an overflow the OVER.30 file will be modified as well so your method doesn't guarantee a good answer.

Also, the problem is that the original poster wanted to promote a job from one environment to another and in that case your method would also show the date/time of the job being created in the new project.
Post Reply