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

Home -> Community -> Usenet -> c.d.o.misc -> Re: [QUESTION] How to time execution of procedure?

Re: [QUESTION] How to time execution of procedure?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 9 Jun 2003 22:25:05 +0200
Message-ID: <ve9rs7sq5gh421@corp.supernews.com>

"Juan Guillermo Fernández V." <promodeus_at_hotmail.com> wrote in message news:bc2nhc$46r$1_at_news1.nivel5.cl...
> Hi. Just a quick question....
>
> How can you set up the periodical or "by date" execution of a procedure?
>
> For example, set up the execution of a specific sequence of commands,
let's
> say, every 1st day of every month?
> Or, on the other hand, set it up to execute, let's say, every 8 hours?
>
> I've been googleing it, but been unable to find a straight answer....
>
> thanks for any help!
>
>

Look for the dbms_job package in your documentation.

Regards

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Mon Jun 09 2003 - 15:25:05 CDT

Original text of this message

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