You can automate both administration tasks that must be executed regularly and those that are executed as needed.
See also:
Concepts of the Database System, Automating Administration Tasks