What to Automate
As was mentioned above there are a number of Remote DBA
tasks that can be automated. Which of these jobs can be automated
using DBMS_JOB? Obviously, DBMS_JOB cannot be used to execute tasks
that require operating system commands (generally speaking).
Therefore, such tasks as backup should be reserved for cron or OEM
type job automation. The type of tasks well suited to automation
with DBMS_JOB are those that can be completely run using PL/SQL.
Jobs such as statistic gathering, internals
monitoring, size monitoring and tuning can be accomplished using
PL/SQL and the DBMS_JOB queues. Even monitoring of remote databases
can be automated using synonyms and database links. Let us examine
some specific tasks and show how they can be automated.