Double-click the tRunJob component to
open its Basic settings view.
If a child Job has been already specified in the component, you
can open its Basic settings view by
right-clicking it and selecting Settings from
the contextual menu, or by clicking the component and then selecting the Component tab.
Click the [...] button next to the
Job field and select the child Job from
the Repository Content dialog box. Leave
all the other parameters as default.
In the Basic settings view of the
tMysqlConnection component, select the
Use or register a shared DB Connection
check box. Then, in the Shared DB Connection
Name field, enter the name of the shared connection defined
in the child Job, shared_mysql_connection
in this example.
Leave all the other parameters blank or as default.
Double-click the tMysqlInput component to
open its Basic settings view.
Select the Use an existing connection
check box and, in case you have more than one connection component in the
Job, select the connection component to be used from the Component List drop-down list.
Click the [...] button next to Edit schema to open the Schema editor, and define the same data structure as in
the child Job.
When done, click OK to close the dialog
and click Yes when prompted to propagate
the schema to the next component.
Specify the table name in the Table
Name list, and click Guess
Query to get the query statement automatically filled in the
Query field.
In the Basic settings view of the
tLogRow component, select the Table mode to display the execution result in
table cells.
Leave the settings of the tMysqlCommit
component unchanged.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!