regarding Start_time and End_time of Job in Parallel Job

[deesh]

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.

[ray.wurlod]

The DSGetJobInfo() function will give you everything you need and more.

[deesh]

Thnx Ray given information DSGetJobInfo(), Ray i am new for the DS i need more can please explain how to use the DSGetJobInfo() it could helpful to me.

[ray.wurlod]

Press F1 when you're in the Designer or Manager client, and use the index to find DSGetJobInfo().

Or why not download EtlStats from Kim Duke's web site which will do all this data gathering, and put the results into a table, for you?