Re: [Q] Oracle scheduler???

From: Eric Keen <e_keen_at_access4.digex.net>
Date: 16 Mar 1995 09:48:56 -0500
Message-ID: <e_keen.795365243_at_access4>


rmanalac_at_us.oracle.com (Roderick Manalac) writes:

>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.

Actually, the stuff is in Oracle 7.1.3 but not documented.

Check out $ORACLE_HOME/rdbms/admin/dbmsjob.sql Received on Thu Mar 16 1995 - 15:48:56 CET

Original text of this message