How to Kill Idle sessions from Navision if not used for specific time (I am using Navision 2009 Classic version)
We are using Windows Logins to log in Navision
](*,) After lots of struggle, finally I am using sql script to kill the Idle connections, which is scheduled to run every 15 min. Purpose is solved. \:D/
file,database,information,sessions,hit F4 on a line to delete it. Boom, session killed. Btw, I've never tried to automate this thing, but you can maybe schedule the deletion through NAS, just try it! (remember to exclude "mysession" session)
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso My Blog
file,database,information,sessions,hit F4 on a line to delete it. Boom, session killed. Btw, I've never tried to automate this thing, but you can maybe schedule the deletion through NAS, just try it! (remember to exclude "mysession" session)
isn't the nas seeing its session as "my session"? :-k
btw, you're right, it's better to filter nas session(s) out, in case you have multiple NASes active
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso My Blog
Comments
Please search the forum..
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
Thanx for your information.
But i don't want to kill idle sessions through SQL querry, i want to kill them directly without SQL.
Is there any other way............
Regards
SJ [-X
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
And the NAS session.
btw, you're right, it's better to filter nas session(s) out, in case you have multiple NASes active
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog