Oracle-L: RE: The best method for scheduled work

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Mon, 06 Jan 2003 01:34:18 -0800
Message-ID: <F001.005275CC.20030106013418@fatcity.com>

Hi Murat Balkas,

Perhaps you want to play around with Oracle's sysdate from dual?
If I am you, I will prepare my sql script then using cron (unix) to execute it (Windows has it's own version of scheduler program come with OS)

I believe most OS equip with scheduler program

Good luck.

Sinardy

-----Original Message-----
Sent: 06 January 2003 17:04
To: Multiple recipients of list ORACLE-L

Hi,

I want to move ( insert into select and than delete from ) some records of a table to another one at midnights. It would be very nice if it has logging facility.

Do you have any good documantation about

scheduled triggers
executing time based queries using sqlplus

Thanks in advance.

Murat BALKAS

Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez.

This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: MURAT BALKAS
INET: murat.balkas_at_o2.net.tr

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sinardy Xing
INET: SinardyXing_at_bkgcomsvc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------