| Table of Contents |
|---|
| outlinh1. true |
|---|
| outlinh1. true |
|---|
| 1 | printablefalse |
|---|
| 2 | stylh1. none |
|---|
| 3 | indent20px |
|---|
|
Row lock instead of page lock
In particular, the /sos/housekeeping/scheduler_cleanup_history job could have problems if a page lock is set in the database tables SCHEDULER_HISTORY and SCHEDULER_ORDER_HISTORY.
Please call the following SQL statements to change the lock level.
MSSQL Server
| Code Block |
|---|
ALTER INDEX SCHEDULER_HISTORY_START_TIME ON SCHEDULER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_HISTORY_SPOOLER_ID ON SCHEDULER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_HISTORY_JOB_NAME ON SCHEDULER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_H_CLUSTER_MEMBER ON SCHEDULER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_O_HISTORY_SPOOLER_ID ON SCHEDULER_ORDER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_O_HISTORY_JOB_CHAIN ON SCHEDULER_ORDER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_O_HISTORY_START_TIME ON SCHEDULER_ORDER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
|
Sybase
| Code Block |
|---|
ALTER TABLE SCHEDULER_HISTORY LOCK DATAROWS;
ALTER TABLE SCHEDULER_ORDER_HISTORY LOCK DATAROWS;
|