Table of Contents |
---|
| outlinh1. true |
---|
| outlinh1. true |
---|
1 | printablefalse |
---|
2 | stylh1. none |
---|
3 | indent20px |
---|
|
In particular, the CleanUpHistory /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);
|
...