Summary

This was again a quick tour through the Scheduler, purely using the currently available graphical tools. We saw DB Console—a web application that comes for free with the database and DbVisualizer—a client-server application. Both have their strong points. The customization of DbVisualizer is so strong that you really should take a look at it.

Finally, we have reached the end of this book. We have seen a lot of the Scheduler and hopefully more than what the PL/SQL packages and Types manual show. The goal was to explain how the Scheduler could be used and how to get most out of it in a step-by-step approach. We began with a simple job, waded through chains, and found out how to control the resource consumption. The newest thing we saw was the remote external job agent that is a great enhancement compared to the classical external job.

We have also seen some advanced items such as event handling, job generation, debugging Scheduler jobs, some real-life scripts, and jobs in RAC databases...