When you execute a SAS Data Integration Studio
job, a return code for each transformation in the job is captured in a macro variable.
The return code for the job is set according to the least successful transformation
in the job. These return codes can be used to test for certain conditions, such as
Successful or
Lookup
Failed. Use the
Status Handling tab
in the property window for jobs and transformations to specify an
action that should be performed when a certain condition is met, such
as
Send Email or
Send Event.
In this way, you can specify actions based on the status of a job
or transformation when it is executed.
For example, if a lookup fails in the process flow for a job, the job can be terminated,
and a status message can be sent to a person, to a file,
or to an event broker that passes the status message to another application. You can
also use status handling to capture job statistics, such as the number of records
before and after an append of the last table loaded in the job. To capture statistics
about a job, select the desired condition to be tested for the job, such as Successful,
and then associate that condition with the Send Job Status action.