Re: scheduling an operation for a later time usin sql or ..
From: Balakrishna Avula <100610.52_at_compuserve.com>
Date: 1996/01/19
Message-ID: <4dnlmm$ir2_at_relay2.uk.mdis.com>#1/1
Date: 1996/01/19
Message-ID: <4dnlmm$ir2_at_relay2.uk.mdis.com>#1/1
Hi,
Use DBMS_JOB package in Oracle 7.1 or later. Or simply write use an Operating system command like 'at' in unix to submit a sqlplus job . Ex. 'sqlplus username/password _at_sqlsciptname parameter list'
Hope this points you in the right direction.
Bala
rkhurana_at_slip.net (Rajeev Khurana) wrote:
>Hi,
>I am trying to find a command in sql or sqlplus which will help me
>schedule some operations. for e.g. start printing contents of a huge
>table at midnight.
>If anyone has any suggestions please mail a response to:
>rkhurana_at_slip.net or post it on this newsgroup.
>Thanks.
>-rajeev.
Received on Fri Jan 19 1996 - 00:00:00 CET