How to kill session?

Hai Raj Patel BCA

I saw the killing session coding in the link u sent but i didnt understand something..I saw a variable Timer of type Automation was declared but what SUBTYPE(Automation server list) was used for creating a Timer variable??? please advise..

rajpatelbca wrote:

you can download this and look into the code it might be help you.

http://www.mibuso.com/forum/viewtopic.p ... in+session

Kill Idle Navision Sessions (SQL scripts)
http://www.mibuso.com/dlinfo.asp?FileID=367
Session Killer
http://www.mibuso.com/dlinfo.asp?FileID=71

just you have to filter those records form session and delete then session will be automatically terminated.

if you want to terminate session automatically then create procession only report and add it in job queue.


Regards,

Hi,Guys

The following code is helpful to kill the Navision Sessions....
There are no more lines to add for this...As it is use the code...

But u should write the code Codeunit 1 in Application Management ..
Write 1 in On Run() and 2 define a function and write it....

Here session is virtual table ..........

Next Run the schedular with codeunit 1 to every 1 min.... What ever the time u given in section 2 ..the session automatically kill.....

1.
OBJECT Codeunit 50025 NAS session monitor 
{ 
  OBJECT-PROPERTIES 
  { 
    Date=10/21/07; 
    Time=[ 8:15:10 PM]; 
    Modified=Yes; 
    Version List=Mibuso,ara3n; 
  } 
  PROPERTIES 
  { 
    SingleInstance=Yes; 
    OnRun=BEGIN 
            IF ISCLEAR(Timer) THEN 
              CREATE(Timer); 

            Timer.StartTimer(6000); 
          END; 

  } 
 
2.
 CODE 
  { 
    VAR 
      Timer@1004 : Automation "{DDADD7CC-AD56-4CA6-9C85-22AE76BF21A1} 3.0:{E7414D60-2D83-44C7-826A-FD14557299F0}:'CP Timer'.cTimer" WITHEVENTS; 
      Session@1000000000 : Record 2000000009; 

    EVENT Timer@1004::TimerEvent@1(); 
    BEGIN 
      Session.SETRANGE("My Session",FALSE); 
      Session.SETFILTER("Idle Time",'>15 min'); 
      IF Session.FINDSET THEN REPEAT 
        Session.DELETE; 
        COMMIT; 
      UNTIL Session.NEXT = 0; 
    END; 

    BEGIN 
    END. 
  } 
} 

Hope so it is useful

it will work in SQL Server option. but i am not sure about Native database.
i think it should work. :-k

yes sure.

vikram7_dabas wrote:

if the user is idle for more than four minutes then thats user session should be killed(Means navision should close if idle time is more than 4 minutes)one of our client wants this requirement.How we will do this?Its a user specific :?:

:shock: FOUR MINUTES !!!!

They will spend more time logging back into NAV all day than they will spend working.