SQL query for EET (Estimated End Time)

[Daryl Brown]

In our AWA v12.3 environment, I've been asked to generate an hourly report that will provide updates on the EET (estimated end time) of a particular long-running workflow.

Now I see that there's an EH_ERTEND field in the EH table, but this seems to only correspond to the 'Estimated End Time' column that you see on the Process Monitoring screen -- it seems to be a static one-time calculation made by adding workflow's start time to its ERT value, as this value does not change as the workflow runs.

What I'm trying to track down is the EET value that you see at the top of the screen when you monitor a given workflow, as this value *DOES* update automatically as the workflow runs.  

Can anyone advise if this EET value corresponds to a particular table/field in the database?  (Or is this value calculated dynamically in some way?)

Thanks in advance!

-- Daryl

[Markus Embacher]

Hi Daryl,

I believe there is no field in the database that holds an updated EET, in my opinion it is calculated from EH_Starttime + EH_ERT. Please note that EH_Starttime is in UTC time.

Regards, Markus

[Daryl Brown]

@Markus -- so does that mean then that the EET you see at the top of a workflow monitor screen is being calculated in real-time?

Is there a way that EET can be calculated manually?  (Presumably it's based on adding up the ERTs of all the tasks in the workflow's critical path, but I'm not sure there's an easy way to identify all of those via a SQL query.  Is there a stored proc or anything I can use that has that logic already encoded?)