Abort all inactive user sessions

Database
yk
N/A

Abort all inactive user sessions

Hi All, would like to find the best practice to automate aborting all inactive sessions after certain amount of time (from SqlAssistant, client sessions). Am planning to for at stored procs and scheduler to perform the abort task on regular basis. Thanks.

Tags (1)
1 REPLY
Senior Apprentice

Re: Abort all inactive user sessions

Of course you could write your own based on the PMon API or MonitorSession and AbortSession from syslib, but this is usually done using Teradata Manager or Viewpoint.

Dieter