As of 7.4.2, there is one SQL job related to AspNetSqlSessionState database, which was released as part of the Data Services installation. The [DatabaseName]_Job_DeleteExpiredSessions SQL job executes the DeleteExpiredSessions stored procedure in the AspNetSqlSessionState database to delete the ASPStateTempSessions table records. By default, this SQL job is scheduled to run once every 24 hours during off-peak hours (default is 2:30 AM). This schedule can be modified as required for each Personify360 installation.
To execute the script:
1. This script must be executed by user that has system administrator privileges on SQL Server.
2. Please specify SQL user that will be used to run the SQL job. Replace value ‘sa’ with SQL user name in line 106.
3. Please specify Database Name by doing a global search and replace for keyword "DATABASENAME" with name of Personify360 database here.
This global replace should update keyword in seven instances.