Update tasklock logic to read directly from prefect's database instead of the webhook #1035
Description
Noora's syncs were locked by system user hours after the job was finished.
Clearly, the webhook notifications are not reliable. They work sometimes and dont work the other time.
We could read the flow run status directly from prefect's database flow_run_state, not using the api but raw sql query.