Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: newbie: scheduled triggers
If your running on an Unix platform you could use crontab to schedule the job
for you .
If your running NT i think you should look into at command.
Perhaps you could make it with the enterprise manager jobschedule ?.
Best regards
Carl Bruhn
crb_at_dde.dk
Beau Green wrote:
> I'm new to Oracle but have taken the first set of PL/SQL classes.
>
> I need my Oracle8 server to run a script every hour. It will open an ODBC
> connection to another type of database server: Forth Shift.
> Reading the foreign database it will create new records in an Oracle8 table.
>
> Where do I create this in Oracle8? It is a trigger? Any key ideals would
> be great; I can read a book from there.
>
> Thanks!
Received on Thu Feb 04 1999 - 01:37:56 CST