Reviewing a Successful Job
Problem
You have run a successful job and want to review data about the job. You also want to examine the job output.
Solution
You can use the interactive
tools that are provided with the Job Editor window.
Perform the following tasks:
Tasks
Check the Status Tab
Click Status in
the Details section of the Job Editor window to display the status of each step in the job. If the Details section is not
displayed, click Details in the View menu
in the SAS Data Integration Studio menu bar. The following display
shows a Status tab that confirms that all
of the steps in a sample job were completed successfully.
Successfully Completed Sample Job
Note: The run-time status of each
node in a job is also shown on the node on the Diagram tab.
The following markers are placed on the jobs:
In addition, you can review the basic properties of
any object in the job. Click the object on the Diagram.
Then, examine the Basic Properties pane for the object.
-
a green check for a status of complete
-
a yellow triangle for a warning
-
red X for an error
Examine the Statistics Tab
Click Statistics in the Details section to display a tabular or graphic presentation of statistics
about the progress of the job. Click the icon for the Display
table view for the statistics tab on the Statistics toolbar
to view a table of statistics. The following display shows the table
for the sample job.
Sample Statistics Table
The statistics table
includes the following columns:
-
Order
-
Name
-
Status
-
Records
-
Start Time
-
End Time
-
Duration
-
CPU Time
-
Current Memory
-
System Memory
-
Current I/O
-
System I/O
-
Server
-
Threads
You can click the icon
for the Display graph view for the statistics tab on
the Statistics toolbar to display a graphical chart. Select Line
Graph to display a graph that charts one or more of the following values for the job:
-
CPU
-
I/O
-
OS I/O
-
Memory
-
OS Memory
-
Real
-
Records
Click Select to choose the values that are included in the graph. The following display shows
a line graph of the sample job.
Sample Line Graph
Note that you can display a summary for a step in the job by positioning the cursor
over its node.
Select Bar
Chart to display a bar chart that illustrates the process duration of each transformation
that is included in the job. Click Select to
pick a single transformation or all transformations for inclusion
in the graph. The following display shows a bar chart of the sample
job.
Sample Bar Chart
You can display a detailed
summary for a transformation by positioning the mouse pointer over
its bar.
If you do not see the
output that you expect on the Statistics tab,
then you can perform the following troubleshooting tasks:
-
When you execute jobs interactively and have run-time statistics enabled, output should be produced. If not, verify that the server is properly configured. See the "Use ARM to Display Runtime Statistics" section in the "Administering SAS Data Integration Studio" chapter of the SAS Intelligence Platform: Desktop Application Administration Guide.
-
When run-time statistics and table counts are enabled but zero records are returned for the row count, verify that the table is not a view. A zero row count is returned for all views.
-
Input and output counts are based on the input and output that are provided by the operating system. When a job has steps that are run on various operating systems, these numbers reflect the metrics that are returned by the operating system.
Examine the Control Flow Tab
Click Control
Flow in the Details section to access a table that consists of the transformations that
are included in the job. These transformations are listed in the order in which they
are run in the job.
The following display shows the control flow table for the sample job.
Sample Control Table
You can click Validates
the control flow to make sure that the flow is valid.
You can also drag a row to a higher or lower position in the table
by clicking on the row number and moving the row either up or down.
This action moves the transformation included in the row to a different
position in the flow; it is run in an earlier or later position.
Control order is the order in which the nodes are run in a job. A warning in the control
flow panel can be displayed when a step is ordered to run
before the step that creates its data has run. For example, suppose there are two
steps in a job in which Step 1 creates data that Step 2 uses, and Step 2 is ordered
to run before Step 1. This arrangement forces Step 2 to run before its data is created.
Step 2 is unlikely to run correctly because it does not have its data yet. If an out
of order scenario is detected, then a warning icon is displayed to warn users that
they might have steps out of order. However, they can still run the steps out of order
if they choose.
Review the Job Output
Right-click the target table of the job. Then, click Open in the
pop-up window to see the output. The target table for the sample job
is shown in the following display.
Sample View Data Window
You can also review basic details about the job in the Runtime Manager at the bottom
of the SAS Data Integration Studio window. If
the Runtime Manager is not displayed, click Runtime Manager in
the View menu in the SAS Data Integration
Studio menu bar. The Runtime Manager is shown in the following display.
Sample Runtime Manager
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 16, 2018