You can automate both administration tasks that must be executed regularly and those that are executed as needed.
? Special DBM commands
0 Automatic log backup
Database Manager GUI, Activating and Deactivating Automatic Log Backup
Database Manager CLI, autolog_on
0 Extending the data area automatically
Database Manager GUI, Switching on/off Automatic Extension of the Data Area
Database Manager CLI, auto_extend
0 Automatic updating of the SQL Optimizer statistics
Database Manager GUI, Updating Statistical Information
Database Manager CLI, auto_update_statistics
? Automatic start
You can also configure the database instance so that it is automatically transferred to the ONLINE operational state when the operating system is started. See Automatic Start.
? DBA planning calendar in CCMS
In SAP systems, you can automate regular administration tasks with the DBA Planning Calendar.
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
You can define a database event for specific states of the database instance. When one of these states occurs, the event dispatcher executes a certain action, such as a DBM command or a command from another program.
? Database triggers
You can use triggers to trigger actions in the database following certain data changes or a restart. See the SQL Reference Manual, Trigger Name (trigger_name)