Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Scheduling Stored Procedures

Re: Scheduling Stored Procedures

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 24 Sep 2005 14:12:01 -0700
Message-ID: <1127596259.874648@yasure>


Jeremy wrote:

> In article <1127397592.571376.245520_at_g47g2000cwa.googlegroups.com>, 
> wpp289 says...
> 

>>Greetings,
>>
>>I'm relatively new to stored procedures, is it possible to schedule
>>these to run, say daily, within the DBMS, or is a
>>call from an external app required?
>>
>>Thanking any kind soul in advance for their assistance.
>>
>>Bill P.
>>
>>
> 
> 
> Use dbms_job to schedule pl/sql procedures
> 
> Google on this:
> 
> http://www.google.co.uk/search?hl=en&q=dbms_job&meta=

Or if 10g: DBMS_SCHEDULER.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Sep 24 2005 - 16:12:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US