The client session

A desktop app session, also known as a client session, is created at Sign On (SO), when a session record is created in the database. The desktop app is not continuously connected to the server. The desktop app connects temporarily at SO and when it polls the server at the check update (CU) interval. The LAST_KEEP_ALIVE time stamp in the session record is updated at each CU and is used to determine inactivity. When the desktop app stops polling the server, the LAST_KEEP_ALIVE time stamp is not updated and the Desktop Sessions Maintenance session maintenance job determines that the session is stale and deletes the record.

When the user shuts down the machine (or locks it and the “Stop checking for updates when Desktop is locked” option is selected in the Desktop App page in Settings in the 

BlackBerry AtHoc

 management system), the user’s session becomes stale because the desktop app stops polling the server and is not able to do a CU. The Desktop Sessions Maintenance job runs every 30 minutes to clean up stale sessions. This job executes the CLEANUP_USER_SESSIONS stored procedure.

For more information, see Appendix C: Database server.