Automating Administration Tasks 

Use

You can automate both administration tasks that must be executed regularly and those that are executed as needed.

Activities

The following options are available to you for automating administration tasks:

·        Scheduler

You can use the scheduler to schedule DBM commands to execute at defined points in time. To do so, you create each DBM command to be executed as a job in the scheduler. The scheduler must be active for jobs to be executed.

See Database Manager CLI, Using the Scheduler

·        Database events

You define a database event for a specific circumstance in the database instance. When this circumstance occurs, the event dispatcher executes a certain action, such as a DBM command or a command from another program.

See Overview of Database Events, Event Dispatcher and Database Manager CLI, Using Database Events

·        Database triggers

You can use triggers to trigger actions in the database following certain data changes or a restart. See the Reference Manual, Trigger Name (trigger_name)

·        Special DBM commands

¡        Automatic extension of the data area

See Database Manager CLI, Extending the Data Area Automatically

¡        Automatic updating of the SQL Optimizer statistics

Database Manager CLI, Updating the Optimizer Statistics Automatically

·        DBA planning calendar in CCMS

In SAP systems, you can automate regular administration tasks with the DBA Planning Calendar.

See also:

Administration