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

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

Re: Scheduling Stored Procedures

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/04
Message-ID: <962692310.15084.0.pluto.d4ee154e@news.demon.nl>#1/1

Use the dbms_job package to submit pl/sql procedure and please don't post to all (and partly non-existing) Oracle newsgroups. There's no need to do that, this is a typical .server issue.

Hth,

Sybrand Bakker, Oracle DBA

"LF" <frolio_at_home.com> wrote in message
news:TAd85.5570$cu1.13149_at_news1.rdc1.ct.home.com...
> Greetings All, I have a procedure that I want to run at the same
> time each night and I am not sure how to do this via Oracle. In
> SQL Server this was done via 'Jobs', in Oracle I cannot find and
> analog. Can anyone tell me how to tell Oracle to run a certain procedure
> at a given time on a given day?
>
> Any help would be greatly appreciated.
>
> L
>
>
Received on Tue Jul 04 2000 - 00:00:00 CDT

Original text of this message

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