I work in a company that uses sql anywhere 12 and need to create a task that would help the workflow a lot. I hope somebody can help or send me in the right direction. I have a little ms sql experience.
There is table, lets call it show_performance_diagnostics, which has a two relevant colums named Number (connection id) and LastReqTime. I don't know if it possible but we need a task that automatically ends the connection if the lastreqtime exceeds 15 minutes.
Right now we have a view that shows show_performance_diagnostics and then we have to manually go to the Connections tab, find the conn. id and end it.