From: nigelc@Cognos.COM (Nigel Campbell) Newsgroups: comp.databases.oracle Subject: Re: [Q] Oracle scheduler??? Date: 27 Mar 1995 00:39:50 GMT Organization: Cognos Incorporated, Ottawa CANADA Lines: 28 Message-ID: <3l51gm$12u@gatekeeper.cognos.com> References: <14MAR95.02098618.0056@music.mus.polymtl.ca> <3k89p3$kch@dcsun4.us.oracle.com> NNTP-Posting-Host: cognos.cognos.com X-Newsreader: TIN [version 1.2 PL2] Eric Keen (e_keen@access4.digex.net) wrote: : rmanalac@us.oracle.com (Roderick Manalac) writes: : >svb@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@cognos.COM CANADA K1G 3Z4