Re: Snapshot error

From: Danut Bancea <danut_at_telepages.ca>
Date: Wed, 30 Aug 2000 17:30:42 -0400
Message-Id: <10604.115925@fatcity.com>

Hi,

You must to run the statement like the owner of the jobs. To find who is the owner run select * from dba_jobs

Danut,

Danut Bancea
Oracle DBA

Tele-Pages Inc.
Phone : (416) 296-9011 Ext. 2271
Fax : (905) 477-7062
E-mail : danut_at_telepages.ca

Original Message ----- From: Murugesan Balakrishnan <mail_oracle_at_YAHOO.COM> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, August 30, 2000 4:17 PM Subject: Snapshot error

> Hello lists,
>
> I setup master and snapshot site using Replication
> Manager 2.0.0. I tried running the default jobs
> created for purge and scheduled link, but it pops up
> with the following error:
>
> Statement: -------------
> BEGIN
> DBMS_JOB.RUN(job=>39); -- 39 was the job number.
> END;
>
> Stack Trace: --------------
> ORA-23421: job number 39 is not a job in the job
> queue.
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
> ORA-06512: at "SYS.DBMS_JOB", line 92
> ORA-06512: at "SYS.DBMS_JOB", line 262
> ORA-06512: at line 2
>
> I recreated this 3 times and I get the same error all
> the times. Can anybody help me on this?
>
> Any help would be highly appreciated.
>
> TIA
> Muru
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> --
> Author: Murugesan Balakrishnan
> INET: mail_oracle_at_yahoo.com
>
> 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).
Received on Wed Aug 30 2000 - 16:30:42 CDT