regarding Start_time and End_time of Job in Parallel Job
Posted: Mon Apr 21, 2008 3:29 am
Hi ray & Friends,
i'm new to DataStage - would appreciate if you can give an example how to use DSGetJobInfo( )
I have one problem in work, please can help to me in solution.
i have 3 TABLEs, i am storing data from 1st table to 2nd table. in the job. here i need start_time and End_time of job which is picking data from TABLE1 and putting data in to TABLE2
These Start_time and End_time i need to maintain in TABLE3.
I used the DS macros but its giving only the Start_time, I need end_ time also can provide kindly any suggestion. through ORCLE also its possible Can suggest to me.
one more thing i have thought to solve through "DSGetJobInfo()" but i didn't see in Parallel jobs this "DSGetJobInfo()"please can guide in this also.
i'm new to DataStage - would appreciate if you can give an example how to use DSGetJobInfo( )
I have one problem in work, please can help to me in solution.
i have 3 TABLEs, i am storing data from 1st table to 2nd table. in the job. here i need start_time and End_time of job which is picking data from TABLE1 and putting data in to TABLE2
These Start_time and End_time i need to maintain in TABLE3.
I used the DS macros but its giving only the Start_time, I need end_ time also can provide kindly any suggestion. through ORCLE also its possible Can suggest to me.
one more thing i have thought to solve through "DSGetJobInfo()" but i didn't see in Parallel jobs this "DSGetJobInfo()"please can guide in this also.