Databases Reference
In-Depth Information
action, such as Send Email or Send Event. In this way, users can specify how a return
code is handled for the job or transformation.
For example, you can associate a return code with an action that performs these
tasks:
aborts the job or transformation
calls a user-defined SAS macro
sends a status message to a person, a file, or an event broker that then passes the
status code to another application
You can also use status codes to capture job statistics, such as the number of records
before and after the append of the last table loaded in the job. To capture statistics
about a job, you would associate a return code with the Send Job Status action.
The
Status Handling
tab, which is included in the property windows for jobs and
for some transformations, is used to associate a return code condition with an action.
However, the property windows for most transformations do not have a
Status
Handling
tab. To return the status of a transformation that does not have a
Status
Handling
tab, you can use a Return Code Check transformation to insert
status-handling logic at a desired point in the process flow for a job. The Return Code
Check transformation can be inserted between existing transformations and removed
later without affecting the mappings in the original process flow.
Note:
The Lookup transformation has its own way of handling exceptions. For
details, see the Help for the
Errors
tab in the property window for the Lookup
transformation.
The Help for SAS Data Integration Studio provides additional information about
monitoring job status. To display the relevant Help topics, do the following:
1
From the SAS Data Integration Studio menu bar, select
Help
Contents
. The
Help window displays.
2
In the left pane of the Help window, select
Task Overviews
SAS Data
Integration Studio Task Reference
Maintaining Jobs
Maintaining
Status Code Handling
.
Displaying Job Status
After you have submitted one or more jobs for execution, display the Job Status
Manager window to view the name, status, starting time, ending time, and application
server that will be used for all jobs that are submitted in the current session. From the
SAS Data Integration Studio desktop, select
Tools
Job Status Manager
to display
the Job Status Manager window.
Using the New Job Wizard
See “New Job Wizard” on page 32.
Working With SAS Data Quality Software
SAS Data Integration Studio has a number of features that can help you to improve
the quality of your data. Except for the Data Validation transformation, these features
require your site to license SAS Data Quality Server software and to complete some
configuration tasks. For more information about setup, administrators should see
“Supporting SAS Data Quality” on page 72.
Search WWH ::
Custom Search