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 (ko78@hotmail.om), December 09, 2001

Answers

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 http://oratcl.sf.net/ - 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 http://purl.org/tcl/wiki/cron for more info.

-- Larry W. Virden (lvirden@yahoo.com), January 02, 2002.