Abort all users sessions after midnight

Viewpoint
New Member

Abort all users sessions after midnight

Dear All,

 

I have to find a way to kill all sessions that users name starts with "PL..." on midnight. I believe that it can by setup on ViewPoint.

Can someone tell me where I can find that option?

 

query for that will be like:

sel TRIM('SYSLIB.AbortSessions (-1, ''*'',')||CAST(SessionNo AS INT)||', ''Y'', ''Y'');' from Dbc.SessioninfoV WHERE Username LIKE 'PL1%'