Hi Guys,
I am in process of designing a event handler for
one of the app over here . So some where in app code it will have one line code
with event_code and some other param. Now in order to keep users unaffected (
due to processing of event) that event is put in queue (AQ) . Some other
to prevent it
starting a head of Oracle.
Haven't tried above myself but as with lots of MS stuff the theory is there
;)
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
From: [EMAIL PROTECTED]
Date: Tue, 1 Apr 2003 22:28:28 +1000
Subject: OT- Start a process
Hi
Slightly OT
I have a couple of programs that need to be run after Oracle has started
and want to run them without a user logging in.
The likely place seems to be in the scheduled tasks running at startup or
as a program under the local run key in the registry.
The processes are a couple of
Hi Peter,
Sounds like a job for an after startup database event trigger (check
out CREATE TRIGGER doco).
Cheers
Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 10:28 PM
Hi
Slightly OT
I have a couple of programs
If you want no user to log in, you may wish to start your database in restricted mode
(and use an account which has the appropriate privilege to log into Oracle if you have
to). The snag is that you have to issue an ALTER DATABASE once your job is done.
Another solution, assuming that your
One other way to go would be to use a system startup script (see
http://support.microsoft.com/default.aspx?scid=kb;en-us;198642 for details)
that first started your db, and then followed up w/whatever other scripted
tasks were necessary. Theoretically, anyway...
HTH,
-Roy
Roy Pardee
From: [EMAIL PROTECTED]
I have a couple of programs that need to be run after Oracle has started
and want to run them without a user logging in.
The likely place seems to be in the scheduled tasks running at startup or
as a program under the local run key in the registry.
The processes are a