Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

manual run job works scheduled job fails

EmuMay 5 2010 — edited May 28 2010

I''m pretty new to using scheduler so I may be missing something basic. However when I run a job manually. ie use dbms_scheduler.run_job it runs fine.

However when the job is scheduled I get:

ORA-04052: error occurred when looking up remote object ORA-04052: error occurred when looking up remote object VDR.VDR@DISTDEV
ORA-00604: error occurred at recursive SQL level 2
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DISTDEV

The passwords are the same....as is demonstrated by how it works when I manually run it. Anyone got any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 25 2010

Added on May 5 2010

#database-key-features, #scheduler

2 comments

2,893 views