Pro Oracle Database 18c Administration: Manage and Safeguard Your Organization’s Data

© Michelle Malcher and Darl Kuhn 2019

Michelle Malcher and Darl KuhnPro Oracle Database 18c Administrationhttps://doi.org/10.1007/978-1-4842-4424-1_20

20. Automating Jobs

Michelle Malcher¹  and Darl Kuhn²

(1)

Huntley, IL, USA

(2)

Morrison, CO, USA

 

In almost any type of database environment—from development, to testing, to production—DBAs rely heavily on SQL statements, blocks of code, and scripts to perform tasks. Typical jobs that DBAs automate include the following:

• Shutdown and startup of databases and listeners

• Backups

• Validating the integrity of backups

• Checking for errors

• Removing old trace or log files

• Checking for errant processes

• Checking for abnormal conditions

Automation comes into play when these scripts, blocks of code, become part of a process ...