Show TOC

Procedure documentationDBA Planning Calendar Locate this document in the navigation structure

 

You can use DBA Planning Calendar to automate database administration. You can schedule, execute, and check almost all regular database administration actions.

Note Note

To start DBA Planning Calendar outside of DBA Cockpit, use transaction code DB13.

End of the note.

Procedure

The initial screen of DBA Planning Calendar comprises the following frames:

  • DBA Planning Calendar

  • Action Pad

  • Calendar

DBA Planning Calendar provides the following information:

System

Select the system you want to use to schedule DBA actions.

Category

Select which type of actions to display in the calendar.

You can display:

  • Only DBA Actions

  • Only External Actions

  • All actions

Calendar ID

Select the calendar ID and a factory calendar.

Specifying the factory calendar affects only the calendar display. Public holidays are displayed in the same color as weekends. This does not cause any restrictions on any actions that have already been scheduled.

Calendar Control

Select the week to display.

The default value is the current week. To navigate to another week, double-click the week you would like to display.
DBA Planning Calendar: Action Pad

The Action Pad provides an overview of actions to schedule jobs periodically.

For SAP HANA, there is currently only the action Complete Data Backup.

DBA Planning Calendar: Calendar

DBA Planning Calendar display actions that are scheduled to run in the background. These actions are executed automatically.

You can use DBA Planning Calendar to schedule, execute, and check almost all regular database administration actions.

Note Note

The database actions required are automatically executed at the time you specify. Therefore, you should make sure in advance that the required resources will be available at the time of execution. You can schedule jobs to be executed periodically. This reduces the amount of effort required to schedule recurring actions.

End of the note.
Scheduling an Action

  1. Open DBA Planning Calendar.

    In DBA Cockpit, choose   Jobs   DBA Planning Calendar  .

  2. To create a new action, you can do either of the following:

    • Double-click a calendar row.

    • Select a calendar cell and choose Add.

    • Drag and drop an action from the Action Pad to a calendar cell in the future. You can also drag and drop actions to reschedule them. To copy an action, hold down the CTRL key while dragging.

    Note Note

    Planning patterns are not available for SAP HANA.

    End of the note.

  3. Specify the action details.

    Planned Start

    Specify the start date and time of the action.

    Action Parameters

    If different from the default, specify the location and prefix for the file.

    Recurrence

    Specify when the action will be repeated or whether it will be executed only once

  4. Choose Add to schedule the action.

    Caution Caution

    The system checks actions that are scheduled within a period of about 30 minutes. If there is a conflict with an existing scheduled action, a warning is displayed. However, you can still schedule the action if there is a conflict. You need to consider if issues will occur affecting access to the database or system performance.

    End of the caution.
Calendar Layout

You can display an overview of scheduled actions for a day, a week, or a month.

To choose a different layout, choose Day, Week, or Month.

To reorder the layout, choose   Administration   Left-Right Split View Layout   or Top-Bottom Split View Layout. The day layout can only be displayed in the left-right split layout.

To change the default layout, choose Save Settings….

Editing an Already Scheduled Action

To edit an action, select the action and choose Edit.

To execute a scheduled action immediately, select the action and choose Execute.

To delete an action, select the action and choose Delete.

Checking Actions

We recommend that you regularly check whether actions have been executed correctly.

DBA Planning Calendar shows the status of each action using the following colors:

Color

Description

Light blue

The action has not been started.

Dark blue

The action has not finished.

Green

The action was completed successfully.

Yellow

The action was completed with a warning.

Search the job log for more information.

Red

An error occurred, and the action was canceled.

Search the job log for more information. Re-schedule the job.

Dark yellow

No additional information is available.

Dark red

Scheduling failed. No status is available and the action is overdue.

To display the meaning of the colors, choose Legend.

To display information about a completed action, double-click the job in DBA Planning Calendar. You can see the times, at which the action was started and finished, as well as the action status. The Program Log tab displays information from the backup catalog.