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


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

Original text of this message