how to do a job in specified time ?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 21 Jan 2003 08:19:52 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703320646@lnewton.leeds.lfs.co.uk>

Perseus,

do you mean 'in a specified time' or 'at a specified time'.

If you mean 'in' - say this job must run in exactly/under 2 hours, then I can't help because there will be/may be all sorts of conflicting jobs running on the server, in the database etc at the same time which could impinge on your 2 hour job.

If you mean 'at' - say this job must start at 12:00 - then you can use cron to fire off an sql script at the required time, or DBMS_JOB (but the start time isn't 100% accurate all the time) inside the database itself.

HTH Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: j [mailto:perseus_medusa_at_hotmail.com] Posted At: Tuesday, January 21, 2003 7:48 AM Posted To: server
Conversation: how to do a job in specified time ? Subject: how to do a job in specified time ?

Hi all ,

I want to copy the content of a table to another table in a specified
time. What options do I have ? Is it possible that I trigger a stored proc
in a specified time in oracle ? How could I do that ?

Thanks.

Perseus Received on Tue Jan 21 2003 - 02:19:52 CST