Show TOC

Scheduling an ActionLocate this document in the navigation structure


You can use the DBA Planning Calendar to schedule actions (for example, data backups, log backups, updates of SQL Optimizer statistics, and database structure checks). These are then performed at the specified time.

  1. Open the DBA Planning Calendar (Setting Up and Using the DBA Planning Calendar).

  2. You can add new actions by:

    a. Double-clicking a calendar cell.

    b. Placing the cursor on a calendar cell and choosing Add.

    c. Using Drag & Drop to drag an action from the Action Pad to a calendar cell.

    d. Choosing Select Pattern to select an action pattern.


    You can also Drag & Drop actions inside the calendar. To copy an action, press the CTRL button while using Drag & Drop.

    You come to a dialog box with an Action Description and other possible entries on the tabs Action Parameters and Repeat.

  3. Action Description: If you have selected option a or b, you can choose the action you want to schedule from the Action field. If you have chosen option c the description of the action is copied from the Action Pad. In the Planned Start field, you can enter the date and time for the action to start.

    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


    If you have selected option d, proceed as described in Action Patterns.

  4. Action Parameters: The parameters for the required action are displayed in Action Parameters. These vary, depending on the action. On the Action Parameters tab page, enter or change the basic parameters for the action.

  5. Repeat: Select the tab page Repeat and enter a repeat pattern.



    Recurrence Pattern

    Interval for the action in weeks, days or hours

    Depending on the selected recurrence pattern, you need to specify the pattern in more detail, that is the days of the week for weeks and the hours of the day for a daily period. The action is repeated at the interval you enter. If you select Once only, the action is executed only once.

    Recurrence Range

    Range of time where the action recurs, that is for a specific time interval or for a limited number of occurrences


    The system warns you if there is a conflict with an existing action. This does not stop you from adding the new action, however. You must decide for yourself if the collision of the actions will affect performance or database access. The underlying collision check does not search for actions with the same start times, it searches for actions within a time period of about 30 minutes.

    Follow the planning concept you chose.

  6. To schedule the action, select Continue.

Editing Previously Planned Actions

To change an entry in an action already scheduled (start, repeat pattern, action parameters), proceed as described in Changing or Deleting an Action.

If you want to execute an action immediately, regardless of its scheduling, proceed as described in Starting an Action Immediately.


The DBA Planning Calendar's schedule is updated. The system checks for conflicts with previously scheduled activities.

If conflicts are found, the system displays them and does not schedule the action. If no conflicts are found, the system includes the action in the DBA Planning Calendar and schedules a background job (or executes the action).

Checking an Action

You should check, at regular intervals, that the actions scheduled are running correctly. You can display the status of each action using the DBA Planning Calendar (Displaying Actions). The Calendar displays unsuccessful actions in a different color.