Marin,
When you run a job manually it gets run by your user
process. When the job runs automatically it's run by
an SNP process. Check the SNP trace file(s) and
alert.log in bdump to see what errors are being
reported by the SNP process when it tries to execute
the job.
HTH,
- Anita
- Marin Dimitrov <marin_at_sirma.bg> wrote:
>
> Hello,
>
> I have problems executing a job that synchronizes a
> ConText index
>
> the job is created with the sample supplied with the
> 8.1.6 installation:
>
> -------------------------------
> declare job number;
>
> begin
> dbms_job.submit(job,
>
'ctx_ddl.sync_index(''portal_owner.domain_index'');',interval=>'SYSDATE+5/14
> 40');
> end;
> -------------------------------
>
>
> yet, peeking into DBA_JOBS I see only failures for
> this job. I don't have
> permission problems because I can execute the
> statement without problems, it
> just fails as a job
>
> thanx in advance,
>
> Marin
>
>
>
> ---------
>
> "When brought to meaning, all importance becomes
> small, as in death,
> all life seems nothing. Knowing is destroyed by
> thinking,
> distilled into knowledge"
>
>
> William Wharton, "Birdy"
>
> --
> Author: Marin Dimitrov
> INET: marin_at_sirma.bg
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Received on Fri Jun 02 2000 - 07:23:34 CDT