Re: How to call a procedure at defined time ?

Many thanks, thatīs it....

Thanks

Armin

Steve Ashmore wrote:

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