Show TOC

DBA Planning CalendarLocate this document in the navigation structure


You can use the DBA Planning Calendar in the Jobs user menu of the DBA Cockpit to automate database administration. You can schedule, perform, and check database administration actions.

You can use the DBA Planning Calendar for almost all regular database administration actions. 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 carry out planning periodically. This reduces the amount of planning required for recurring actions.



SAP liveCache Technology: In accordance with the Authorization Concept, the user was assigned one of the roles SAP_BC_LVC_ADMINISTRATOR or SAP_BC_LVC_SUPERUSER.


The DBA Planning Calendar can be called as follows:

  • Open the DBA Cockpit (transaction DBACOCKPIT) and choose Start of the navigation path Jobs Next navigation step DBA Planning Calendar End of the navigation path.

  • The DBA Planning Calendar can be opened using the Central Calendar. Open the DBA Cockpit (transaction DBACOCKPIT) and choose Start of the navigation path Jobs Next navigation step Central Calendar End of the navigation path. You can find information about the Central Calendar in the following sections: Central Calendar, Using the Central Calendar.

The initial screen of the DBA Planning Calendar includes the following frames: DBA Planning Calendar, Action Pad, Calendar

DBA Planning Calendar

The top left frame (DBA Planning Calendar) contains all the information and parameters for choosing actions that should be displayed:

  • System: Select the system for which you want to schedule DBA actions.

  • Calendar ID: Select the calendar ID and therefore a factory calendar.

    Specifying the factory calendar only affects the calendar display. Public holidays are displayed in the same color as weekends. This leads to no restrictions on any actions already scheduled.

  • Planning Mode: You can select planning mode.

    Local: Planning is carried out for the system that you selected.

    Global: Planning is carried out for all integrated, attainable systems. This type of procedure may be necessary, for example, if database structure checks are to be carried out on all systems.

  • Calendar Control: With Calendar Control you can select the week that should be displayed.

    The default value is the current week. To navigate to another week, double-click the week you would like to display.

Action Pad

The Action Pad contains a list of all schedulable actions currently available for the database system.

Table 1: Action Pad

Task Area

Entry in the Action Pad

Short Name

Data and Log Backups

Complete Data Backup

Complete Data Backup (Bridge)

Incremental Data Backup

Activating Automatic Log Backup

Deactivating Automatic Log Backup

Log Backup

Archive Log Backup Files








Determining Statistics for the SQL Optimizer

Select Tables for Update Statistics

Update Statistics for Selected Tables

Update All Optimizer Statistics




Database Structure Checks

Check database structure of the snapshot

Check the Database Structure

Check the Database Structure (Tables Only)




Determine Table Size and Growth

Update Table Statistics


Determine Class Container Sizes (SAP liveCache technology only)

Update Class Container Statistics


Checking Backups

Check Complete Data Backup

Check Incremental Data Backup

Check Log Backup




Execute DBM Commands

Executing DBM Commands



The calendar can be displayed with either a weekly, daily or monthly view using either a top-bottom layout or left-right split view layout. To change the layout, choose Start of the navigation path Administration Next navigation step Left-Right Split View  End of the navigation path or Top-Bottom Split View Layout. To change, for example, from a weekly view to a daily or monthly view, choose the corresponding button in the application toolbar.


You can only change the layout for the week or month view. For the day view, only the left-right split view layout is available.

To change your preferred settings - that is, the layout and the view - choose Save Settings.

The calendar shows the actions that were scheduled using background processing. These actions are then automatically executed.

Once the action has run, the status is indicated using the following colors:

You can display the meaning of each color by choosing Legend.

Dragging & Dropping Actions

You can move or copy actions in the DBA Planning Calendar using Drag & Drop; from the Action Pad to the Calendar too, for example.