In this example, execute the actions in the 'MyNewMapActions' list and impose a time limit of 12 hours. Then, invoke two concurrent worker procedures to perform the actions.
Session 1:
CALL TDMaps.ManageMoveTablesSP(NULL, NULL, 'MyNewMapActions', 720, 'Y', :ActionsCompleted, :NumErrors, :TimeExpired); Procedure has been executed. *** Total elapsed time was 11 hours 19 minutes and 49 seconds. ActionsCompleted NumErrors TimeExpired ---------------- ----------- --------------- 85 0 'N'
Session 2:
CALL TDMaps.MoveTablesSP(‘P’,NULL,NULL,NULL,NULL); Procedure has been executed. *** Total elapsed time was 11 hours 3 minutes and 5 seconds. Session #3: CALL TDMaps.MoveTablesSP(‘P’,NULL,NULL,NULL,NULL); Procedure has been executed. *** Total elapsed time was 11 hours 19 minutes and 45 seconds.