Controlling ETL Services

The ETL Control option on the Tools menu is available only for customers using the new ETL process. It allows Administrator users to control ETL services from within the application. You have the options to stop or start all services at once, and to stop, start, pause or resume one service node at a time. The actions available for a node depend on the state of the service. For example, if the node status is Stopped, the only action available will be Start. Each time you initiate a control option, you are prompted with a message that asks if you want to continue. If an error occurs while data is being loaded, an error message is displayed. See the Import Services Guide for more information on the new ETL process.

To start all services:

  1. From the Tools menu, choose ETL Control. This displays the ETL Services Control screen.

  2. Click the Start All Services button at the top of the screen. This displays the Start All Services Confirmation prompt.

  3. Click OK to start all services. The status for each service in the list will be set to Running. Click Cancel, if you want to close the message without starting all services.

To stop all services:

  1. Click the Stop All Services button at the top of the screen. This displays the Stop All Services Confirmation prompt.

  2. Click OK to stop all services. The status for each service in the list will be set to Stopped. Click Cancel, if you want to close the message without stopping all services.

To stop a single service:

  1. In the Nodes list, select a service that is in Stopped status.

  2. Click the Action icon in that row, and choose Stop. This displays the Stop Service prompt.

  3. Click OK to stop the service. The status for the service in the list will be set to Stopped. Click Cancel, if you want to close the message without stopping the service.

To start a single service:

  1. In the Nodes list, select a service that is in Running status.

  2. Click the Action icon in that row, and choose Start. This displays the Start Service prompt.

  3. Click OK to start the service. The status for the service in the list will be set to Running. Click Cancel, if you want to close the message without starting the service.

To pause a single service:

  1. In the Nodes list, select a service that is in Running status.

  2. Click the Action icon in that row, and choose Pause. This displays the Pause Service prompt.

  3. Click OK to pause the service. The status for the service in the list will be set to Paused. Click Cancel, if you want to close the message without pausing the service.

To resume a single service:

  1. In the Nodes list, select a service that is in Paused status.

  2. Click the Action icon in that row, and choose Resume. This displays the Resume Service prompt.

  3. Click OK to resume the service. The status for the service in the list will be set to Running. Click Cancel, if you want to close the message without resuming the service.

 

 

_____________________________