Procedure documentationAutomating Administration Tasks Locate this document in the navigation structure

 

As an administrator of a database, you must periodically carry out a number of administration tasks. In addition to these, you may need to carry out further administration after specific system events have occurred.

Some of these administration tasks can be automated using special automating functions, others can be planned with the scheduler, triggered by events or triggers, or planned with the DBA Planning Calendar.

Procedure

Automating Functions
Scheduler

You can use the scheduler to schedule DBM commands to be executed in a database at specified times. For that purpose, you log on to the database and create a job in the scheduler for every DBM command to be executed. You must activate the scheduler for jobs to be executed.

The scheduler uses a separate DBM server process for the connection to the database. Therefore, the scheduler remains active when you stop the database.

More information: Database Manager CLI, Using the Scheduler Function

Database Events

You can define that database events are triggered under specified circumstances, and that certain actions are carried out in response to these events, for example sending an e-mail, executing a DBM command or a executing a command from another program.

More information:

Database Triggers

You can use database triggers to trigger actions in the database following certain data changes or a restart.

More information: SQL Reference Manual, Trigger Name (trigger_name)

DBA Planning Calendar

In SAP systems, you can plan periodic administration tasks with the DBA Planning Calendar.

More information: Database Administration in CCMS, DBA Planning Calendar