Scheduling Actions in the DBA Planning Calendar

Scheduling Actions in the DBA Planning Calendar

Use

This section tells you how to schedule actions in the DBA Planning Calendar, which is part of the Computing Center Management System (CCMS).

Prerequisites

You are ready to use CCMS. Refer to Getting Started in CCMS with Informix DBA.

If you want to change or delete an action, it must be in the state SCHED (that is, not already executed).

If you want to insert an action, you must choose today or a later day, and if you choose today, you must choose a time after the current time.

If an action has already been executed, you can only display it. See Checking the Results of Actions in the DBA Planning Calendar.

Procedure

Choose Tools ® CCMS ® DB Administration ® DBA Planning Calendar to start the DBA Planning Calendar.

Choose the day you want, by double clicking on the day’s header bar.

The system displays actions already scheduled on the chosen day.

To insert a new action, do the following:

Choose Create action.

The system displays the actions supported by the Planning Calendar for your database platform.

Select the action you want to schedule.

The system shows the basic parameters currently set for the action.

Enter the basic parameters for the action as follows:

Parameter	What to enter	For example
Start time	The time when the action is to start, using 24-hour clock notation. Choose Start immediately, if you are entering an action for today and want to start the action immediately.	17:00 This means the job is to be executed at 5 o'clock in the afternoon.
Period	The interval for the action, in weeks. The action is repeated at the interval you enter. If you do not enter a value, the action is run once only.	2 This means the action is to be repeated on the same day and time every two weeks.
Calendar	Select the calendar for your country or area.	US This means the calendar for the United States is to be used.

The system warns you if there is a conflict with an existing action. If so, you must choose another time for the action.

Depending on the action you are inserting, the system may prompt for further input parameters.

If necessary, enter further input parameters.
Choose Continue to insert the action.
To change an existing action, do the following:

Select the action you want to change.
Choose Change action.

The system shows the basic parameters currently set for the action.

If required, change the basic parameters for the action. Refer to the table shown in the previous step.

The system warns you if there is a conflict with an existing action. If so, you must choose another time for the action.

If required, choose Parameters to change the parameters specific to the action (for example, the tape volume to use for a backup).
Choose Continue to save your changes.

To delete an existing action, do the following:

Select the action you want to delete.
Choose Delete action.

The system asks you to confirm the deletion.

Confirm the deletion.

The system deletes the action, including the corresponding background job. Deletion of the job also stops automatic periodic repetition of the action, if that was scheduled.

If an action is one of a sequence, you can only change or delete the next scheduled occurrence of the action. If you do this, the system also deletes all future occurrences of the action in the same sequence.

For example, you cannot change or delete an action scheduled to run in six weeks’ time, if the next action of the same sequence is scheduled to run next week. Instead, you have to change or delete the occurrence for next week.

If you have inserted a new action or changed an existing one, make sure that any resources required by your change or insertion are available.

Result

The schedule of the DBA Planning Calendar is updated with the results of your insertion, change, or deletion.

DBA Planning Calendar (Informix)