Maintaining Jobs

Overview

This chapter assumes that you are familiar with the basic information about Jobs as described in Jobs and are ready to define the Jobs to create your data stores. A Job enables you to connect a series of process steps into a single unit. You can specify the processes for a Job in two ways:

Define a Process Flow in the Process Editor. If a Process Flow exists, SAS/Warehouse Administrator will generate code for the Job.

A Process Flow is a diagram composed of symbols with connecting arrows and descriptive text that illustrate how data moves from input source(s) to output table(s) and what extractions and transformations occur in between. The icons represent the data stores, and the text boxes represent data preparation processes. The top icon is the output table that is created by the Job. In the Process Flow, data moves from the bottom to the top as shown in the following Process Flow:
Supply user-written code that contains the processes to create the data store(s). When you supply the code, a Process Flow is not required. However, you might want to define one for documentation purposes and to take advantage of the ability of SAS/Warehouse Administrator in that it can generate LIBNAME statements for the input sources specified in a Process Flow. For an example, see Define Process Editor Job, which illustrates defining a Process Flow for creating an ODD in which user-written code is supplied.

In addition to specifying processes, a Job may also include the following:

scheduling metadata, which enables the Job to be executed in batch mode at a specified date and time. See the "Scheduling Jobs" chapter in this document.
a Job Flow, which is a user-defined diagram in the Job View of the Process Editor that defines metadata for Job dependencies. It is composed of symbols, with connecting arrows and descriptive text, that illustrate the sequence in which Jobs and Events are executed. Job Flows are not required.

Note: The current release of SAS/Warehouse Administrator does not generate code for Job Flows. To use them, you must write a Metadata API program that reads Job Flows and generates code for them. For details, see SAS/Warehouse Administrator Metadata API Reference, Release 2.3.

In general, to maintain Jobs, do the following:

Add a Job for the data store.
Define the Job properties, such as whether the Job code will be generated by SAS/Warehouse Administrator or supplied by user-written code.
For SAS/Warehouse Administrator to generate code, define the Job Process Flow, which initially requires the output table and an input source. Typically, a Mapping process is added automatically to the Process Flow when you specify an input source. You must then define the Mapping properties.
For a Process Flow, you might need to add additional output tables and input sources, which also require you to update the Mapping properties.
For a Process Flow, after you have output table(s) and input source(s) specified, you might need to specify additional processes to further prepare data for loading into the output table(s). These include User Exit, Data Transfer, and Record Selector processes, which require you to define their properties.
For a Process Flow, if necessary, you might need to edit the Load process properties. Note that the code to perform the Load process can be generated by SAS/Warehouse Administrator or supplied by user-written code, except for an ODD or a Detail Logical Table, which must be user-written.
Execute the Job interactively, or schedule the Job to run in batch mode at a future date and time.

This chapter focuses on the general procedures for maintaining Jobs. For unique information about Jobs for a specific data store, see the examples in the chapter associated with the data store.

Note: The basic steps for defining a Job are described in the online Help for each type of data store. To display the relevant online Help, in the SAS System Help contents, select Help on SAS Software Products Using SAS/Warehouse Administrator SoftwareFinally, select defining a specific type of data store, and then select the topic for adding and updating the data store Job. In addition, you can display help for most SAS/Warehouse Administrator windows by clicking Help on the window. [cautionend]

Top of Page