Viewing or Updating Job Metadata

Problem

You want to view or update the metadata that is associated with a job. All jobs have basic properties that are contained in metadata that is viewed from the job properties window. If you want SAS Data Integration Studio to generate code for the job, then the job must also have a process flow diagram. If you supply the source code for a job, then no process flow diagram is required. However, you might want to create one for documentation purposes.

Solution

You can find metadata for a job in its properties window or process flow diagram.

Tasks

View or Update Basic Job Properties

Perform the following steps to view or update the metadata that is associated with the job properties window:
  1. Find the job on the SAS Data Integration Studio desktop. Common job locations include the following:
    • the Jobs folder in the Inventory tree
    • the My Folder folder
    • the Shared Data folder
    • a folder nested in the User folder
  2. Right-click the desired job. Then, click Properties in the pop-up menu to access the properties window for the job.
  3. Click the appropriate tab to view or update the desired metadata.
For details about the metadata that is maintained on a particular tab, click the Help button on that tab. The Help topics for complex tabs often include task topics that can help you perform the main tasks that are associated with the tab.
Note: A one-minute screencast (video demonstration) of this task is available at http://support.sas.com/documentation/onlinedoc/etls/.

View or Update the Job Process Flow Diagram

Perform the following steps to view or update the process flow diagram for a job:
  1. Locate the job.
  2. Open the job by using one of the following methods:
    • Double click the job.
    • Right-click the job. Then, click Open in the pop-up menu.
    Both methods display the process flow diagram for the job in the Diagram tab in the Job Editor window.
  3. View or update the metadata displayed in the process flow diagram by using one of the following methods:
    • To update the metadata for tables or external files in the job, see Viewing or Updating Table Metadata or Viewing or Updating External File Metadata.
    • To update the metadata for transformations in the job, open the properties window for the transformation and update the appropriate tabs.
    • To add a transformation to a process flow diagram, select the transformation and drop it in the Job Editor window.
Note: Updates to job metadata are not reflected in the output for that job until you rerun the job. For details about running jobs, see Submitting a Job for Immediate Execution.