Hi, I wanted to get the list of suspended flows from the tableau server without using background_jobs table. Could you please explain me how to do

Hi Pooja,

Could you please elaborate on what you are referring to? We have already tried joining tasks with flow_runs, but we are only getting state = 0.

For refresh extracts and subscriptions, we joined them with the tasks table and were able to retrieve the task states as 0, 1, and 2 successfully. However, in the case of flows, we are not able to get these states and are only seeing state 0.

Please refer to the screenshot below for more details.

Thank You!