Updating a end date timestamp

mdtauseefhussain · Post by **mdtauseefhussain** » Thu Oct 11, 2007 1:47 pm

Hi All,

I have sequence of jobs which takes current date as ap parameted to run.
and once those sequence of jobs complete i need to updated the end datetimestamp ,i tried using a shaned container which will pass sysdate and time from dual and updated the table ,but when the job completes i can see the start date timestamp not the end date timestamp in the database .can any one tell me if there is any function or routine for updating Enddate timestamp like Dsstarttimestamp i dont remember the exact name.

Regards
Tausif

ray.wurlod · Post by **ray.wurlod** » Thu Oct 11, 2007 2:40 pm

Easiest would be a server job (called from the job sequence at the end) to perform this task. It could interrogate the system clock directly (via the Date() and Time() functions for example) rather than selecting sysdate from dual.

chulett · Post by **chulett** » Thu Oct 11, 2007 5:05 pm

Interesting discussion here that might help:

viewtopic.php?t=104817