Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2014
    Posts
    2

    Question Unanswered: End connections automatically

    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 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.

  2. #2
    Join Date
    Nov 2014
    Posts
    2
    Nobody?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •