Re: Jobs stills executed after OEM crash

"Robert" <cookie - remove - @tref.nl> wrote in message news:bou1od$hr4$1_at_reader11.wxs.nl...
> Hi there,
>
>
>
> I have an 8.1.7 DB running on NT4
> We use OEM from 9.0.2 on a W2k box.
>
> I have created a job which calls a .cmd file on the db server once at
night.
> This script logs on to the DB and does a "backup controlfile to trace"
> Afterwards the backup controlfile is copied to another machine.
>
> I don't like loosing my controlfiles so it is to be safe.
>
> But a week or two ago my OEM server crashed.
> We were trying OEM so it ran on a "older" server.
> We liked OEM and we decided to buy ourselfs new hardware and install OEM
> from scratch. This takes a couple of day to do right (and installing it on
> Linux this time :-))
>
> So for 5 days the DB did not have contact with the OEM server.
> We saw that the script was still executed every night
>
> I thought that it had to have contact with the repository to do that ??
> Guess not, it has to store jobs loccally !!
>
> My question is: Where does a server (the intelligent agent i guess) store
> the job definitions ??
> And can i edit them without using OEM ??
>
>
>
>
> Cheers,
>
> Robert

I see you have had no luck with meaningful replies, so I'll give this a whirl.

If you check out ORACLE_HOME\network\agent, you'll find a bunch of .q files, one of which is "job.q". It's not very readable, so no it's not editable outside of OEM. But it's this file which the Intelligent Agent uses to run jobs against the target database. So, although your repository database collapsed, the file was still there, the intelligent agent was still running, the job still got performed.

Regards
HJR Received on Wed Nov 12 2003 - 14:37:47 CST