Maintaining Jobs

Example: Defining a Job for Which User-Written Code is Supplied

This example defines a Job for which user-written code is supplied, which means that a Process Flow is not required. The Job creates one output table (a Detail Table), with one input source (an ODD).

Note that when you supply the Job code, you are responsible for allocating any SAS libraries that are referenced in the code. For example, you can include the appropriate LIBNAME statements in the user-written code or in an autoexec file to be executed when SAS is invoked.

Alternatively, you could use SAS/Warehouse Administrator to generate LIBNAME statements for the input source(s) specified in a Process Flow. That is, you could create a Process Flow even though one is not required because the data store is created with user-written code. The following explanations do not take advantage of this approach, but an example is available in Define Process Editor Job, which illustrates defining a Process Flow for creating an ODD in which user-written code is supplied.

Note: The following explanations describe the metadata and methods used to achieve the desired results. It is assumed that the appropriate Data Warehouse Environment, Data Warehouse, Subject, Detail Table physical properties, and ODD exist. [cautionend]

Adding a Job

To open the Process Editor, in SAS/Warehouse Administrator Explorer, from the menu bar, select Tools Process Editor

[untitled graphic]

In the Job Hierarchy, position the cursor on the Data Warehouse for which you want to define a Job, for example Toy Store Whouse, click the right mouse button, and select Add JobThe software adds a Job icon to the Job Hierarchy.

[untitled graphic]

Note: By adding the Job using this method, there is not an output table associated with the Job and therefore there is not a Process Flow. [cautionend]

Defining Job Properties

To update the default metadata for the Job, position the cursor on the Job icon, click the right mouse button, and select Properties. The Job Properties window displays for you to enter the appropriate information.

General Tab

specifies the Job name, a description, an owner, and an administrator.

[untitled graphic]

Source Tab

specifies that the code for the Job is supplied by user-written code. SAS/Warehouse Administrator will not generate code for the Job. When the User Written option is selected, the SAS library and the catalog entry name containing the code must be specified.

[untitled graphic]

The Edit button opens an editing window where you can enter, view, or update the specified code. Here is an example of code for the Job:

[untitled graphic]

The remaining tabs in the Job Properties window, which are for Job scheduling, are explained in the online Help for this window. See also the "Scheduling Jobs" chapter in this document.

Top of Page