O'Reilly logo

Oracle Database 12c PL/SQL Advanced Programming Techniques by John Harper, Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required