Re: SymRep and Job Queue problem

Phil,

   I don't use symmetric replication but use DBMS_JOB quite extensively.  Have you ever been able to get jobs to run automatically? There are some INIT.ORA parameters that need to be set (like JOB_QUEUE_PROCESSES) before DBMS_JOB will automatically run jobs. From the looks of your output it doesn't look like that is you problem thought, just a thought.

The insufficient privileges would appear to be the problem, but the quesion is on what? I recall we had some problems with our databases (7.2. or 7.3) when it appeared that much of the symmetric replication stuff was moved (either to or from the SYS account). Might want to check and make sure that it is in the right place.

Also, were you logged on as REPADMIN when you created the job in the job queue (and when you tried to run it). Maybe the insufficient privileges stem from the job having been created under the wrong account or being run from the wrong account (for symmetric replication I don't know who those should have been created.run by: repadmin, sys, etc.).

Just some thoughts,

Chris H. Received on Thu Mar 06 1997 - 00:00:00 CST