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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Kill sql process

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

nfbioit
Starting Member

2 Posts

Posted - 2014-11-21 : 02:34:03
quote:
Originally posted by tkizer

You'll want to post your question on a site that specializes in Sybase. SQLTeam.com is for Microsoft SQL Server.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/



Okaaaay. Thanks
Go to Top of Page
   

- Advertisement -