EndTime

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
amsh76
Charter Member
Charter Member
Posts: 118
Joined: Wed Mar 10, 2004 10:58 pm

EndTime

Post by amsh76 »

Is there anyway we can get the End Time of the Job. We can get startDate and Start Time, but not End Date and End Time using DS Constants..? Any Ideas?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

When do you pick up the job's exit status? Straight after DSWaitForJob? Grab the system time then.

Code: Select all

FinishTimeStamp = Oconv(Date(),"D-YMD[4,2,2]") : " " : Oconv(Time(),"MTS:")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Get the timestamp of the most recent event in the job log file.

Code: Select all

Event = DSGetNewestLogId(hJob, DSJ.LOGANY)
Entry = DSGetLogEntry(hJob, Event)
TimeStamp = Field(Entry, "\", 1, 1)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply