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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Agent doesn't like early mornings?!!

Re: Oracle Agent doesn't like early mornings?!!

From: Terry Engelstad <terry_at_interaccess.com>
Date: Wed, 18 Nov 1998 12:20:59 -0600
Message-ID: <72v3ft$k74$1@supernews.com>


What form of authentication are you using? Oracle's or NT's? Is there any definition in the User database that limits access to certain hours? Does anything show up in the Event Log?

Bill Buchan wrote in message <72rfs3$vg$1_at_phys-ma.sol.co.uk>...
>Oracle Agent is behaving most oddly; I'd very much appreciate any input on
>the following puzzle:
>
>I have a set of 3 jobs which the agent should execute once a day. If I set
>the start time during 'normal office hours' they all work fine, but if I
set
>the start time to be during the night only the first one runs and then the
>agent 'hangs' and does not respond to any prompting. It has to be stopped
>and restarted and the jobs deleted. I have tried setting the start time to
>4am, 5am, 8am, 9am, 10am and 4pm. Only 9am, 10am and 4pm work properly.
>
>I know that the Agent is meant to be 'intelligent' - but I think it having
>the intelligence to object being dragged from its bed at 4am to do some
work
>is a bit too extreme! Whether the client on which I set up the jobs
>originally is still connected or on or off has no impact on the behaviour
of
>the agent (not that any should be expected). The server is an NT box
>running Oracle 8.0.4. (agent is v.8.0.4). There are no backups or any
>other scheduled jobs running overnight.
>
>Any insights gratefully received!
>
>Thanks
>- Bill.
>
>
Received on Wed Nov 18 1998 - 12:20:59 CST

Original text of this message

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