Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Help with DBMS_JOB
Thank you!
L120bj wrote in message <20010216084412.04529.00000234_at_ng-cb1.aol.com>...
>>Subject: Help with DBMS_JOB
>>From: "Nobody" nobody_at_logica.com
>>Date: 2/15/01 5:07 PM GMT Standard Time
>>Message-id: <982256872.494764_at_ernani.logica.co.uk>
>>
>>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.
>
>Hi,
> Try the following link
>http://www.cs.umbc.edu/help/oracle8/server803/A54642_01/index.htm
>Regards,
> Rob
Received on Fri Feb 16 2001 - 12:39:33 CST