DataFlux Data Management Studio 2.7: User Guide

Running and Reviewing a Process Job

Overview

Once you have created and configured a process job, you can submit it for processing and review the output. Perform the following steps:

• Run the Process Job
• Review the Process Job Outputs

Run the Process Job

Perform the following steps to run the process job:

1. Open the process job, if necessary.
2. Click Show Details Pane, if needed, to view the Log tab for the process job.
3. Click Run Process Job to run the job.
4. Review the log to make sure that all of the nodes in the process job have completed successfully. Note, for example, that 1703 records are read in the SQL Query node and 1703 records written in the Data Target node.

   Note that you can double-click any row in the log to see more information in a Details dialog. For example, you can double-click the row for the If Then node to see the dialog shown in the following display:

   

   This dialog lists inputs and outputs for the selected node.

   Finally, you can review the full text of the Platform log. See Accessing Logs to learn how to access the Platform log and the other log files that are provided for DataFlux Data Management Studio.

   Any temporary files that are generated by the job, such a sort files, are saved to the location that is specified in the BASE/TEMP option in a DataFlux configuration file, if this option has been set. If the BASE/TEMP option has not been set, temporary files will be written to the temporary file location that is specified for the operating system. To see if the BASE/TEMP option has been set, select Tools > Data Management Studio Options > Job > Advanced.

Note: You can also execute a process job using batch mode or from the command line. To run your process job in batch mode, go to the toolbar and select Actions > Run as Batch Job on Management Server… and follow the instructions in the Export to Data Management Server wizard. To process your process job using the command line, see Running Jobs from the Command Line.

Review the Process Job Outputs

Perform the following steps to review the outputs of the process job:

1. Locate the output tables in the Data Connections riser. This job sends output to the following tables: dmsample_echo_CA, dmsample_echo_NC, and dmsample_echo_VA. These tables reflect the default values column (NC;VA;CA) in the source table, which you can see in the Inputs tab for the Table of Data Echo node. You can see the same state abbreviations in the run time value column in the Inputs tab for the Work Table Reader node.
2. Double-click an output table to open it in a Data tab. The following display shows a portion of the data in dmsample_echo_CA: