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

From: Paul Dixon <antispam_at_bt.com>
Date: Tue, 10 Jun 2003 12:44:21 +0100
Message-ID: <bc4gp9$h60$1@pheidippides.axion.bt.co.uk>

"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?

Juan,

you can do this within the database using dbms_job, or alternatively use a scheduler within your server operating operating system e.g.cron (Unix) to run a script.

Paul Dixon Received on Tue Jun 10 2003 - 06:44:21 CDT