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

Terry Engelstad wrote in message <72v3ft$k74$1_at_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?
>

Hi,

I'm using Oracle's authentication and there is nothing in the database to limit access to certain hours (at least nothing I've set up and I've been the only one using it!). Compaq Insight Agent is running on the Server and records the following message in the event log every time that the first job runs at night (and hangs the agent):
"The Compaq Insight Agents have detected a process exception: PID: <pid> - DESC: DBSNP" This doesn't help me much!

>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 Thu Nov 19 1998 - 03:01:20 CST