Scheduling Jobs: Scheduling Jobs :: SAS/Warehouse Administrator(R) 2.0 User's Guide

Scheduling Jobs

Before SAS/Warehouse Administrator can generate the code that schedules a Job, at a minimum, you must have

a scheduling server definition for the computer where the Job will run
an appropriate Jobs Information library.

For details about the preparation required for Job scheduling, see Preparing for Job Scheduling.

To have SAS/Warehouse Administrator schedule a Job, at a minimum, you must open the properties window for the Job and enter information on the Date/Time tab and the Server tab. For details about these tabs, click Help on the Job Properties window.

Tracking Jobs

If Job tracking is enabled for a given Job, when the Job executes, it will update its status in the appropriate Jobs Information library. The Job Viewer window reads the Jobs Information library to display information about Jobs that have been submitted.

Job tracking through SAS/Warehouse Administrator is enabled by default. A Job scheduled through SAS/Warehouse Administrator will be tracked through SAS/Warehouse Administrator unless job tracking has been disabled for the Job on the Prolog/Epilog tab of the Job Properties window.

Example: Scheduling and Tracking a Job with the AT Command

This example describes how to schedule and track a Job for a local data store on a Microsoft Windows or Windows NT computer. The appropriate scheduling server definition and Jobs Information library are assumed to exist, although brief instructions for adding these items are included in the example.

Note: The steps for scheduling a Job using System V CRON are very similar to the steps described here. The main difference is that you would select a CRON definition on the Server tab for the Job. [cautionend]

Display the Job for the data store. In the SAS/Warehouse Administrator Explorer, right-click the data store and select Process.

The Job will be displayed in the Process Editor, as follows:

In the left panel of the Process Editor, the data store's Job and output tables will be listed. In the previous display, the output table for the Job has a rectangle around it. Note that the output table has a parent. This parent is the Job.
(Optional) Position the cursor on the Job, and click the left mouse button to select it, as follows:
Position the cursor on the Job, click the right mouse button, and select Properties. The Job Properties window displays, as follows:
Select the Date/Time tab. The tab displays, as follows:

At a minimum, use the arrows to select a date and a time for the Job to execute. For details about the fields on this tab, click Help.
Select the Server tab. The tab displays, as follows:

Use the arrow to select a scheduling server definition that is appropriate for the Job. In the current example, the definition should generate an AT command that will execute the Job on the local host. To see a scheduling server definition that would be appropriate for the current example, see Example: Creating an AT Scheduling Server Definition.
Select the Prolog/Epilog tab. The tab displays, as follows:

In the Prolog/Epilog tab above, note that the Default to server option is selected. This means that the Tracking tab of the properties window for the scheduling server definition specified for this Job will determine whether this Job will be tracked in SAS/Warehouse Administrator. For the current example, assume that the definition specified on the Server tab has its Job tracking option selected.

You are now finished entering the metadata required to schedule this Job.
Click Schedule.
Click Yes when asked if you want to save the metadata for the current Job. The Job Scheduling Status window displays. It presents a series of messages about the status of the Job, as follows:

When the messages are all displayed, click Go Back to return to the Job Properties window.

Note: If you get a message that says that the maximum length for an AT command has been exceeded, you must edit the scheduling server definition that is specified for this Job. Click Go Back to return to the Job Properties window. Click the Server tab, then click the right arrow and select Edit existing scheduling server. For details about what updates are required to fix the problem, see Preparing to Create an AT Scheduling Server Definition.

Note: If you get a message about the Jobs Information library not being defined, you must create a new one--or register an existing Jobs Information library--before you can schedule a Job in the current Warehouse Environment or Data Warehouse.

It is possible that an appropriate library has been defined, but has not yet been registered as the Jobs Information library for the current Warehouse Environment or Data Warehouse. In that case, cancel the scheduled Job and register the Jobs Information library as described in Registering a Jobs Information Library. Having done that, you can come back to the same Job and schedule it again. These steps will prevent you from creating multiple Jobs Information libraries.

Alternatively, you might know that an appropriate Jobs Information library does not exist. In that case, click Yes when asked if you want to create a Jobs Information library. A properties window displays. For details about that window, click Help.
From the Job Properties window, click OK. You are returned to the Process Editor.

After you have scheduled a Job, you can view it, as described in Viewing Scheduled Jobs.

Summary: Scheduling a Job with the Null Scheduler

This example summarizes how to schedule a Job using the Null Scheduler definition rather than an AT or CRON definition. For a discussion of how this can be useful, see Summary: Creating and Using a Null Scheduling Server Definition.

The steps required to perform this task are very similar to those described in Example: Scheduling and Tracking a Job with the AT Command. The critical difference is that on the Server tab of the Job Properties window, you would specify a Null Scheduler definition. An example of such a Server tab follows:

[untitled graphic]

Top of Page