Scheduling DBA Tasks by Using UNIX Job Scheduler
For those DBAs managing Oracle on UNIX, TOAD offers the ability to schedule shell scripts that perform true server-side database administrative tasks. Plus, TOAD ships with over 50 very useful shell scripts that work on Linux, Solaris, HPUX, AIX, and Tru64 already provided. Moreover, TOAD provides a simple template for creating additional scripts. TOAD simply utilizes the server’s cron daemon to schedule and run the tasks. The TOAD Unix Job Scheduler is shown in Figure 5.33 and is located on the main menu at DBA, OS Utilities, Unix Job Scheduler. Its tree view contains two basic node types at the first level: one entry for All Available Tasks and an entry for each database server.