Product Knowledge Base

Space shortcuts

Page tree

Row lock instead of page lock

In particular, the /sos/housekeeping/CheckDaysSchedule job could have problems if a page lock is set in the database table DAYS_SCHEDULE.
Please call the following SQL statements to change the lock level.

MSSQL Server

 ALTER INDEX DAYS_SCHEDULE_SCHEDULER_ID ON DAYS_SCHEDULE SET (ALLOW_PAGE_LOCKS = OFF);
 ALTER INDEX DAYS_SCHEDULE_JOB_CHAIN ON DAYS_SCHEDULE SET (ALLOW_PAGE_LOCKS = OFF);
 ALTER INDEX DAYS_SCHEDULE_PLANNED ON DAYS_SCHEDULE SET (ALLOW_PAGE_LOCKS = OFF);
 ALTER INDEX DAYS_SCHEDULE_EXECUTED ON DAYS_SCHEDULE SET (ALLOW_PAGE_LOCKS = OFF);

Sybase

 ALTER TABLE DAYS_SCHEDULE LOCK DATAROWS;