Teach Yourself PL/SQL in 21 Days- P12: Welcome to Sams Teach Yourself PL/SQL in 21 Days, Second Edition. The fact that you purchased this book indicates that you have an interest in learning the PL/SQL language, which is Oracle’s relational database procedural programming language. It allows you to develop powerful and complex programs to access and manipulate data in the Oracle8i database. We have attempted to include as many examples of PL/SQL code as possible to illustrate PL/SQL features | Managing Database Jobs 527 I Hello Again for the Second Time 06-22-97 09 38 35 PM Hello World 06-22-97 09 38 36 PM Hello Again for the Second Time 06-22-97 09 38 36 PM Hello World 06-22-97 09 39 36 PM Hello Again for the Second Time 06-22-97 09 39 36 PM Hello World 06-22-97 09 39 37 PM Hello Again for the Second Time 06-22-97 09 39 37 PM Hello World 06-22-97 09 40 38 PM Hello Again for the Second Time 06-22-97 09 40 38 PM Hello World 06-22-97 09 40 38 PM Hello Again for the Second Time 06-22-97 09 40 38 PM Hello World 06-22-97 09 41 38 PM Hello Again for the Second Time 06-22-97 09 41 38 PM Hello World 06-22-97 09 41 38 PM Hello Again for the Second Time 06-22-97 09 41 38 PM Hello World 06-22-97 09 42 39 PM Hello Again for the Second Time 06-22-97 09 42 39 PM Hello World 06-22-97 09 42 39 PM Hello Again for the Second Time 06-22-97 09 42 39 PM Hello World 06-22-97 09 43 40 PM Hello Again for the Second Time 06-22-97 09 43 40 PM Hello World 06-22-97 09 43 40 PM Hello Again for the Second Time 06-22-97 09 43 40 PM Hello World 06-22-97 09 44 40 PM 18 Your output might be a lot longer depending on when you view this file. Notice that the two procedures HELLOFLE and SHAREFLE are appending to the phrase and the date and time every minute. 528 Day 18 Summary Today you have learned how to work with the DBMS_JOB package in Oracle8i. This package handles all jobs by using background processes to check for jobs to execute at a specific interval and then places them in job queues. To submit a job for processing you must submit the job to the queue first. After a job is submitted if you are the owner you can change the parameters. You can also fix any of your broken jobs as well as remove your own jobs from the queue. This chapter also covered the techniques used to run a job immediately. You can also import and export jobs from one database to another. Always remember that the job number is unique and any attempt to use the same job number will result in a failure of
