Is there any table/view inside RSA DB schema from which we can fetch the queue time or run time of running data collection ?
Is there any table/view inside RSA DB schema from which we can fetch the queue time or run time of running data collection ?
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
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
Hope this helps
Regards
Kristian