Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Running a script on shutdown/startup

Re: Running a script on shutdown/startup

From: Jurij Modic <jmodic_at_src.si>
Date: Mon, 31 May 1999 19:16:27 GMT
Message-ID: <3755de1e.2129865@news.siol.net>


On Mon, 31 May 1999 17:14:42 +0100, "Richard Anstey" <ranstey_at_compuserve.com> wrote:

>Hello,
>
>Has anyone come accross a way of getting a script to run automatically when
>the shutdown command is issued ? I need to run a command to stop several
>jobs before the db is shutdown. I'm running on 7.3.4 but would also be
>interested if a solution exists in 8.

The solution exists in 8i (8.1) - it is called "database event triggers". You can write triggers that execute at special database events like startup or shutdown.

>Many thanks for any suggestions,
>
>Richard.

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Mon May 31 1999 - 14:16:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US