Managing extract-transform-load operations

A computer program product for managing ETL (extract-transform-load) operation execution, the computer program product comprising one or more computer readable storage devices and program instructions collectively stored on the one or more computer readable storage devices, the stored program instructions comprising:

• program instructions to receive an updated ETL (extract-transform-load) job flow;
• program instructions to determine affected stages of a current ETL job flow;
• program instructions to send a message to stop data flow for all unaffected stages of the current ETL job flow;
• program instructions to send a switch message along the current ETL job flow through the affected stages;
• program instructions to receive notice of receipt of the switch message downstream from the affected stages of the current ETL job flow;
• program instructions to move an affected stage of the current ETL job flow from one side of a remote stage to another side of the remote stage;
• and
• program instructions to resume data flow according to the updated ETL job flow.

A computer system for managing ETL (extract-transform-load) operation execution, the computer system comprising:

• one or more computer processors;
• one or more computer readable storage devices;
• and
• stored program instructions on the one or more computer readable storage devices for execution by the one or more computer processors, the stored program instructions comprising:
• program instructions to receive an updated ETL (extract-transform-load) job flow;
• program instructions to determine affected stages of a current ETL job flow;
• program instructions to send a message to stop data flow for all unaffected stages of the current ETL job flow;
• program instructions to send a switch message along the current ETL job flow through the affected stages;
• program instructions to receive notice of receipt of the switch message downstream from the affected stages of the current ETL job flow;
• program instructions to move an affected stage of the current ETL job flow from one side of a remote stage to another side of the remote stage;
• and
• program instructions to resume data flow according to the updated ETL job flow.