Job Start Time
Posted: Mon Jan 17, 2005 11:09 pm
Hello,
We have a status table where we want to insert the start time of the job when it starts. Once the Job is finished, we want to update the same row with the end time, number of rows read etc.
We have taken JobName and StartTime as the Key.
The problem is when we are running Job. We are taking
DSGetJobInfo(DSJ.ME, DSJ.JOBSTARTTIMESTAMP)
in the transformer and inserting in the status table.
And in after Job we are calling a routine which internally executes the same DSGetJobInfo(DSJ.ME, DSJ.JOBSTARTTIMESTAMP) function for the same Job and calculates other additional information.
The Problem is the starttime from the transformer and the starttime calculated from the routine differs by a second or so. It is not at alll possible for us to update the table as the timestmp differs.
Please suggest how can we get the same time from both.
also we tried to get JOBPID but getting 0 always in case of parallel Jobs.
We have a status table where we want to insert the start time of the job when it starts. Once the Job is finished, we want to update the same row with the end time, number of rows read etc.
We have taken JobName and StartTime as the Key.
The problem is when we are running Job. We are taking
DSGetJobInfo(DSJ.ME, DSJ.JOBSTARTTIMESTAMP)
in the transformer and inserting in the status table.
And in after Job we are calling a routine which internally executes the same DSGetJobInfo(DSJ.ME, DSJ.JOBSTARTTIMESTAMP) function for the same Job and calculates other additional information.
The Problem is the starttime from the transformer and the starttime calculated from the routine differs by a second or so. It is not at alll possible for us to update the table as the timestmp differs.
Please suggest how can we get the same time from both.
also we tried to get JOBPID but getting 0 always in case of parallel Jobs.