Re: Scheduling a task

Denis Ethier wrote:
>
> I would like to start a particular stored procedure once per day
>
> How do i do that
>
> Denis Ethier
> dethier_at_clickon.com

Try this:
declare
jobno number;
begin
dbms_job.submit(jobno, 'procedure;',sysdate,'sysdate+1'); end;

You must include the ";" after the proceudre in the call to dbms_job.submit.
This will create an entry into dba_jobs which is somewhat similiar to cron on unix.

Glenn Ferguson
glenn_at_home.net Received on Wed Apr 30 1997 - 00:00:00 CDT