Adding Checkpoints to a Job

Problem

You want to mark selected transformations as restart points in a job. If the job fails to complete successfully, you want to be able to rerun the job from the point where it failed.

Solution

You can set checkpoints for appropriate transformations in the job. If the job fails to run successfully, you will be able to restart it from either the last successful checkpoint or from the beginning of the job. You also must specify a library for the saved-state information for the job. Finally, you can specify an optional library for the work tables in the job. Perform the following tasks:

Tasks

Add a Checkpoint to a Transformation

Perform the following steps to add a checkpoint to a transformation:
  1. Open a SAS Data Integration Studio job.
  2. Right-click a transformation and click Assign as Restart-Point in the pop-up menu. The Restart-point Setup window is displayed.

Specify Libraries for a Checkpoint

Perform the following steps to specify one or both libraries for the checkpoint:
  1. Specify a saved-state library in the Restart-point state library field. You can click Select a library to select an existing library or click New to register a new library. After you have specified a library, you can click Properties to access its properties window. Note that the saved-state library must be local to the server executing the job.
  2. You can also specify an optional library to save the temporary tables in the job in Alternative library for temporary tables (optional) field. You need this library only when your job requires the SAS work tables that were created in previous steps when you restart it. You can either select an existing library or register a new library. For details about redirecting output, see Redirecting Temporary Output Tables.
    Note: As implemented, the save-state feature does not save the SAS WORK library during a checkpoint. You must determine whether any particular checkpoint-flagged step (or subsequent step) requires the SAS WORK tables created in preceding steps. If so, you must change the physical location of those temporary tables as part of the job design. If the temporary tables are left in SAS WORK, a rerun with a restart pending can result with “Table-not-found” errors. You can change the location on the Physical Storage tab of the properties window for the temporary table. You can also use the Alternative library for temporary tables (optional) field to specify the default temp library for the job to be something other than SAS WORK.
  3. Click OK to close the Restart-point Setup window.
    Note: You can specify one or both of the libraries for the checkpoints in all new jobs. Use the Restart-point state library and Alternate library for temporary tables on the Code Generation tab of the Options window. You an access the Options window at Toolsthen selectOptions in the menu bar.
  4. Right-click any additional transformations that require checkpoints and click Assign as Restart-Point in the pop-up menu. The following display shows the Diagram tab for a sample job with checkpoints.
    Sample Job With Checkpoints
    Sample Job With Checkpoints
    Note the checkpoint icon overlays (checkpoint icon overlay) in the upper-right corners of the Splitter transformation and the first Extract transformation.