Re: [Q] Oracle scheduler???

Eric Keen (e_keen_at_access4.digex.net) wrote: : 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?????
 

: >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.
: Check out $ORACLE_HOME/rdbms/admin/dbmsjob.sql

Can someone answer the following:

1. Can a procedure schedule another procedure
2. Once a scheduled-procedure is created, can it be manipulated such as changing when/frequency etc
3. Would I be able to create a procedure which woke up at intervals and based on some logic 'connect' to the database as another user if I knew their login name/password

--
Nigel Campbell		  Voice: (613) 738-1338 ext 3016    P.O. Box 9707
Business Intelligence       FAX: (613) 738-0002             3755 Riverside Dr.
Cognos Incorporated	    MCI: nigel campbell || 3074729  Ottawa, Ontario
UUnet: nigelc_at_cognos.COM                                    CANADA  K1G 3Z4