i have a scheduled script running in my application. I see it the "All Active Transactions" (v_transaction.list) table. But after deactivating the scheduled script i still see it there. Why and how to make sure the script is removed from Active transactions list once its been deactivated? The scheduled script runs periodically every 15 mins. It is a conditional script which also has code to deactivate the scheduled script if the condition is not met and the script isn't required. Can I add something to the condition script to make sure the transaction is killed when the script is deactivated? Or is there some other automated solution without manually killing the transaction?
