Project and Portfolio Management Practitioners Forum
cancel

Line execution Start & End time

Highlighted
Akif Saburi
Super Contributor.

Line execution Start & End time

Hi,

I have requirement to create report to find the Line execution start and Line execution end time in the package. But I am not able to find the tables in which execution start and end date are stored.

Can someone please help.

Thanks
2 REPLIES
Vibhor Dwivedi
Super Contributor.

Re: Line execution Start & End time

you can make a command and insert details of start time and end time of a package line or execution step in a separate table. Later you can create a report which can fetch that data for you.



to_date(substr('[PKGL.P.STARTTIME]',1,19),'yyyy-mm-dd hh24:mi:ss')
to_date(substr('[PKGL.P.ENDTIME]',1,19),'yyyy-mm-dd hh24:mi:ss')

Here [PKGL.P.STARTTIME] token return start time of a package line.
Akif Saburi
Super Contributor.

Re: Line execution Start & End time

Thanks