The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Line execution Start & End time

Highlighted
Akif Saburi
Regular Collector

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
Regular Collector

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
Regular Collector

Re: Line execution Start & End time

Thanks
//Add this to "OnDomLoad" event