Re: Oracle Jobs.

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 07 Nov 2005 04:47:49 -0800
Message-ID: <1131367672.897024@yasure>

IANAL_VISTA wrote:

> johnparcels_at_gmail.com wrote in 
> news:1131298687.486536.85170_at_f14g2000cwb.googlegroups.com:
> 
> 

>>Hi All,
>> I want to create a job in Oracle 10g. The job contains just a stored
>>procedure that would be used to populate the table(s) in Oracle. Later
>>I would be scheduling the job on a regular interval.
>>How to go about that? Or is there a better way to achieve this?
>>
>>Thanks in advance
>>
>>JohnP.
>>
>>

> 
> 
> Visit http://tahiti.oracle.com
> and do a keyword search for "DBMS_JOB"

Actually DBMS_JOB is deprecated in 10g: Still there but only for purposes of backward compatibility.

Look instead at DBMS_SCHEDULER.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Nov 07 2005 - 06:47:49 CST