scheduling jobs with scripts : LUSENET : Tool Command Language (Tcl) : One Thread

Is it possible to write scripts in oracle which schedule tasks for example to update certain table at a certain time. I want this to be done with a script not by using the enterprise manager. Should the script be written using TCL or what??

-- John fann (, December 09, 2001


Hi! I don't know anything about Oracle Enterprise Manager other than that it has some embedded use of Oracle. What I use when doing Oracle with Tcl is to make use of - a Tcl extension. I then can write regular Tcl scripts and update Oracle tables.

For setting scripts off to run at a particular time, take a look at one of the cron type programs that are available. I think there are even Tcl based cron programs - check for more info.

-- Larry W. Virden (, January 02, 2002.

Moderation questions? read the FAQ