CHAPTER9
dbms_scheduler Package
Purpose
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 dbms_job package.
The problem with writing one-off scripts is two-pronged. The first problem is the complexity involved in performing routine ...
Get Oracle Database 12c PL/SQL Advanced Programming Techniques now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
