BatchProcessTypeLimit Table
BatchProcessTypeLimit
is a table storing the limits placed on the parallel
execution of tasks within the Batch Processor. A limit is associated with one
or more BatchProcessType
s. The limit value is the number of tasks of the
associated types that may be executed at any one time.
Note that these limits are applied after the standard parallel execution
restrictions are applied. This means that these limits will not generally
affect a single tenant system. They will take effect only if the limit
is applied to types that are allowed to run in parallel for a tenant.
For example, if a limit is applied to a types that run the ComplianceReader
executable, the Business importer and the ARL import, it may be possible to
reach the limit.
In a multi-tenant system, the limits allow the system administrator to define reasonable limits to try to ensure that the Batch scheduler does not overload the hardware it is allotted.
Database Column |
Details |
---|---|
BatchProcessTypeLimitID
|
Type: integer. Key. Generated ID A unique identifier for a |
Name
|
Type: text (max 128 characters). Key The name of this |
MaxTasks
|
Type: integer The number of tasks associated with this limit that may be executed in parallel by the Batch scheduler. A zero or negative value in this column will cause the limit to be ignored. |
MaxTasksPerServer
|
Type: integer The number of tasks associated with this limit that may be executed in parallel by the Batch scheduler on each database server, when running in multi-database mode. A zero or negative value in this column will cause the limit to be ignored. |