Re: [Q] Oracle scheduler???
Date: 16 Mar 1995 03:02:59 GMT
Message-ID: <3k89p3$kch_at_dcsun4.us.oracle.com>
svb_at_euronet.nl (Smits_van_Burgst) writes:
|> > It's possible with Oracle 7 to start a Oracle job at the hour
|> >we want, like scheduler?????
|> > If yes, how to make that possible???
|>
|> If you are using Unix, yes look at cron / crontab / at
|>
|> for other OS I don't know
|>
|> hope it help
|>
|> Frank Fesevur
Eventually, in Oracle7.2 there will be a DBMS_JOB package to execute stored procedures at a certain time (and interval). However, this will probably only allow you to run jobs within the RDBMS itself. If you want a generated report written out to a file, you will have to fallback to having a cron-like job run an application at the OS level.
Roderick Manalac
Oracle Corporation
DISCLAIMER: Implied.
Received on Thu Mar 16 1995 - 04:02:59 CET