Re: How to start a SP scheduled?

From: <sybrandb_at_yahoo.com>
Date: 17 Dec 2003 04:22:16 -0800
Message-ID: <a1d154f4.0312170422.670e9bea@posting.google.com>

Lars Steinmetz <lsteinmetz_at_nurfuerspam_jakrause.com> wrote in message news:<1071646276.249154_at_news.thyssen.com>...
> Hello NG,
>
> how can I start a stored procedure with a timer. E.g. a stored procedure
> should be executed once an hour.
>
> Thanx.
>
> Lars

variable ijobno number;
execute dbms_job.submit(:ijobno,'<your
procedure>',sysdate,'trunc(sysdate+1/24,''HOUR'')'; commit

init.ora's job_queue_processes must be non-zero to do this

Sybrand Bakker
Senior Oracle DBA Received on Wed Dec 17 2003 - 06:22:16 CST