Deploying Jobs as Stored Processes

Problem

You want to make a job available to any application that can execute a SAS stored process.

Solution

Deploy the job as a stored process.

Tasks

Deploy a Job as a Stored Process

Perform the following steps to deploy a job as a stored process:
  1. In the Inventory tree or the Folders tree on the SAS Data Integration Studio desktop, right-click the job for which you want to generate a stored process. Then select Stored Processthen selectNew from the pop-up menu. The first window of the Stored Process wizard is displayed.
    General Tab
    General Tab
  2. In the first window, enter a descriptive name for the stored process metadata. You might want to use a variation of the job name. Enter other information as desired. For details about the fields in this window, select Help. Click Next to access the Execution tab of the wizard.
  3. Specify a SAS server, a source repository, a source filename, any input stream, and any output type (result type) for the new stored process. The following display shows some sample values for this window.
    Execution Tab
    Execution Tab
    Click Next to access the Parameters Tab screen, where you can specify any parameters that you need for the stored process.
  4. Click Next to access the Data screen, where you can specify any data sources and targets that are used by the stored process.
  5. Click Finish. A stored process is generated for the current job and is saved to the source repository. Metadata about the stored process is saved to the metadata server. A metadata object for the stored process is added to the Stored Process folder in the Inventory tree.
After the job has been deployed, it can be executed with any application that can execute a SAS stored process.
Copyright © SAS Institute Inc. All rights reserved.