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, then associate that condition with the
Send Job Status action.