pymssql 2.2.1 driver
43 views
Skip to first unread message
Sudheer Krishna
Sep 24, 2021, 5:53:37 PM9/24/21
to pymssql
Hello,
im having some issue with MssqlOperator. My goal is run one sql storedprocedure.
sp Behaviour:
parent sp is having table queue and checking the status in a loop in queue if its completed or not. Parent sp calls child sp. When child sp starts running it has to update queue table
When im running this through airflow - dag, child sp call which inturn getting locked by parent sp as it is reading.
When im running this directly in sql session - its executing fine.
Does anyone dealt with MssqlOperator and came across this scenario ? pls help.
im having some issue with MssqlOperator. My goal is run one sql storedprocedure.
sp Behaviour:
parent sp is having table queue and checking the status in a loop in queue if its completed or not. Parent sp calls child sp. When child sp starts running it has to update queue table
When im running this through airflow - dag, child sp call which inturn getting locked by parent sp as it is reading.
When im running this directly in sql session - its executing fine.
Does anyone dealt with MssqlOperator and came across this scenario ? pls help.
Reply all
Reply to author
Forward
0 new messages