can anyone help me out in searching the queue time and run time attribute collection attribute? we have searched the whole schema but did not found anything.Is there any logic to determine this attribute?

Hi!

I have not found any way to extract queue time from the database, but start and end time are available in T_DATA_RUN_TASKS.

Those two can be used in calculations to get runtime in seconds. The below will return a fair bit of data, depending on your system and you'll probably want to specify the exact columns you want. run_time is in seconds

SELECT (end_time-start_time)*24*60*60 AS run_time, task.*, TDC.NAME
FROM T_DATA_RUN_TASKS task
JOIN T_DATA_COLLECTORS tdc ON task."SOURCE" = tdc.ID
WHERE task.TYPE = 'DataCollection'

Hope this helps

Regards

Kristian