Creating a Job That Contains Jobs

Problem

You want to create a job that contains one or more existing jobs.

Solution

You can add existing jobs from a tree view to the Diagram tab of the Job Editor window in an open job. These jobs are added to the control flow in the order in which they are added to the job. This sequence is useful for jobs that are closely related, but the jobs do not have to be related. You can always change the order of execution for the added jobs in the Control Flow tab of the Details pane.

Tasks

Create a Job That Contains Existing Jobs

Perform the following tasks to create a job that contains existing jobs:
  1. Create an empty SAS Data Integration Studio job.
  2. Drag one or more existing jobs from a tree view to the Diagram tab of the Job Editor window. The completed sample job is shown in the following display.
    Completed Job
    Completed Job
Note that the added jobs are linked by dashed-line control flow arrows and not by solid-line data flow arrows. Be default, the extract job in the sample job, which was added first, will be executed first. Then the sort job, which was added second, will be executed.