Re: How to call a procedure at defined time ?

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Wed, 22 May 2002 05:45:56 -0500
Message-ID: <uemtnkkadudv8b@corp.supernews.com>

You can use UNIX cron.
Or better yet use the Oracle supplied DBMS_JOBS. This one will run every hour. (Although the time will slightly skew each time thru)

declare
job_no number;
begin
dbms_job.submit(job_no, 'your_sp;', trunc(sysdate+1),'SYSDATE+1/24'); end;
/

to see what jobs you have scehduled run

select * from dba_jobs;

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"Armin Kast" <Armin.Kast_at_WPM-Ingenieure.de> wrote in message news:3CEB6E32.5040009_at_WPM-Ingenieure.de...
> Dear all,
>
> I have a Procedure and i want to call this
> every 2 hours. How can i do this ?
>
> Thanks in advance
>
> Armin
>
Received on Wed May 22 2002 - 05:45:56 CDT