Help with DBMS_JOB

Hi all,

I am currently using oracle 8i running on a unix machine (SunOS v5.6). I'd like to run a procedure which is executed every half an hour - not a problem using dbms_job! The problem is "how" do I use the package? Unfortunately, the Oracle 8i manuals are with our clients (since they supply our development environment for developing their systems). I have tried looking in the 2nd edition of O'Reilly's Oracle PL/SQL programming book (which includes Oracle 8), but it only contains the headers for the procedures within dbms_job - no examples. I've also tried looking on the on-line manuals here:

http://www.cs.umbc.edu/help/oracle8/server803/A54654_01/toc.htm

but I can't seem to find any information regarding dbms_job.

I would really appreciate it if anyone out there could point me in the right direction so that I can at least see an example of how it is used. I'm sure it is very simple - but I just can't seem to find the info.

On a lighter note, could anyone recommend some good quick-reference SQL*Plus and PL/SQL books.

Thanks in advance. Received on Thu Feb 15 2001 - 11:07:13 CST