We have a Database Query against a MS SQL server that has been running for three days.
I tried to stop it with right click, Cancel Task, but it doesn't stop.
Is this correct? Or should the "Cancel Task" feature cancel also a Database Query?
Is there any other way to stop this without restarting Matillion?
Just FYI:
- We don't have access yet to the source database to check the status of the session of transaction.
- Matillion instance is used by several departments, it is not that easy for us to restart Matillion.
Thank you in advance!
Hello @fernando.hidalgo
I just noticed your post and may have some information that can help you out.
If you have console access to the MSSQL server, then killing the query there would be an ideal process.
When you control-right click on the task, then you'll see an additional 'cancel task and continue' option. I do not believe this kills the connection thread correctly (if at all) so it may lead to resource exhaustion, especially if used repeatedly. However, it should work for your case scenario.
I hope that helps and please continue to post your questions and offer support to our community.
Kind regards, Joe
Thanks, that is a good trick!