scheduling jobs with scriptsgreenspun.com : 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 (firstname.lastname@example.org), 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 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 (email@example.com), January 02, 2002.