Re: Job queue in oracle

From: Neilc <neilc-olops_at_btinternet.com>
Date: Wed, 1 Sep 1999 11:58:05 +0100
Message-ID: <7qj0v2$4i9$1@pheidippides.axion.bt.co.uk>

Example to run procedure proc with parameter arg1 and run it immediately, then every day afterwards :-

variable x number;
execute dbms_job.submit(:x,'proc(''arg1'');',sysdate,'sysdate+1');

lily99_at_my-deja.com wrote in message <7qisgq$8ai$1_at_nnrp1.deja.com>...
>Can someone tell me how I can put an Oracle stored
>procedure in job queue using dbms_job. Thanks in advance.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Sep 01 1999 - 05:58:05 CDT