The purpose of this chapter is to introduce you to Oracle’s
dbms_scheduler package and to give you practical knowledge regarding this excellent tool. Oracle introduced this program in its Oracle Database 10g release. At that time, its key benefits were its ability to start, stop, and reuse jobs. It represented a huge leap forward in job management. At least, it’s a huge leap over the previous scheduling method, which combined the Linux or Unix
cron utility and Oracle’s
The problem with writing one-off scripts is two-pronged. The first problem is the complexity involved in performing routine ...