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 on a calendar cell.
b. Positioning the cursor on a calendar cell and selecting Add.
c. Dragging&Dropping an action from the Action Pad to a calendar cell.
d. Selecting an action pattern.
You can also Drag&Drop actions inside the calendar. To copy an action, press the CTRL button when Dragging&Dropping.
A dialog box appears with the details of an action.
3. If you select option a or b, you can choose the action you want to schedule from the Action Description group box.
If you choose option c, the description of the action is copied from the Action Pad.
If you select option d, proceed as described in Action Patterns.
In the Planned Start field, you can enter the date and time for the action to start.
4. 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. Select the tab page Repeats and enter a repeat pattern.
Intervals for the action in weeks, days, or hours.
Depending on which repeat patterns are selected, you may have to input details into the pattern (days of the week for a week and hours of the day for a day) The action is repeated regularly at the interval specified by you. If you select Once only, the action is only executed once.
The time after which the action is repeated, that is, for a certain time interval or for a limited number of scheduled actions
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 Add.
To start the action immediately, select Execute.
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 any are found, the conflict is displayed and the action is not scheduled.
If no conflicts are found, the system includes the action in the DBA Planning Calendar and schedules a background job (or executes the 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. The DBA Planning Calendar displays unsuccessful actions in a different color.