Bug in DSGetJobInfo DSJ.JOBELAPSED?

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

Post Reply
cconley
Premium Member
Premium Member
Posts: 4
Joined: Fri Nov 12, 2004 12:21 am
Contact:

Bug in DSGetJobInfo DSJ.JOBELAPSED?

Post by cconley »

I think I have encountered a problem with the DSGetJobInfo function for the Elapsed Seconds (DSJ.JOBELAPSED). I have examples where a job starts before midnight and finishes after midnight and the function returns 0 seconds.

However, if i generate a job report with dsjob, it reflects the correct amount of seconds.

We are running version 7.5.1.A.

Has anyone else encountered this?

Thanks,

Chris
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

The elapsed time is based on after the SQL statement returns. This changes the rows per second number. I know, weird.
Mamu Kim
Post Reply