Purpose
Moves a group of tables within a certain time limit out of the ActionsTbl and into the ActionQueueTbl queue table.
Syntax
CALL [TDMaps.] ManageMoveTablesSP ( ['JobNumber',] 'SerialTableActionList', 'ParallelTableActionList', { 'TimeLimit' | NULL }, 'GroupActions', :ActionsCompleted, :NumErrors, :TimeExpired ) [;]
- TDMaps.
- The name of the database.
- 'JobNumber'
- An optional job number recorded in the history table.
- 'SerialTableActionList'
- Named list of table actions to perform by only one session.
- 'ParallelTableActionList'
- Named list of table actions to perform by one or more sessions.
- 'TimeLimit'
- Maximum time in minutes for executing actions. The valid range is 1 to 10080 (7 days). NULL indicates an unlimited duration.
- 'GroupActions'
- 'Y' indicates related actions are scheduled and executed in a strict grouped fashion.
Output Parameters
Output parameters include:
- :ActionsCompleted: The number of actions that were successfully completed.
- :NumErrors: The number of actions that encountered a failure.
- :TimeExpired: 'Y' indicates the time limit was exceeded prior to completing all actions in TableActionList. Otherwise, the parameter is 'N'.