Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nfbioit
Starting Member
2 Posts |
 Posted - 2014-11-20 : 10:09:53
|
| Hi,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 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. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-11-20 : 11:36:14
|
| You'll want to post your question on a site that specializes in Sybase. SQLTeam.com is for Microsoft SQL Server.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
nfbioit
Starting Member
2 Posts |
|
|
|
|
|
Kill sql process