Re: How to execute another users job?

You can not run jobs that are not in your own job queue. You should try to get the password, but if you can not, then connect as SYSTEM and reset the password (set new password for userX, run the job as userX, restore userX old password). No need to know userX password.

connect system/password

SELECT username, password FROM dba_users WHERE username='X';

USERNAME                       PASSWORD
------------------------------ ------------------------------
X                              9F56C14116139736

ALTER USER userX IDENTIFIED BY new_password;

>From a new SQLPLUS Window connect as user X and run the job:

CONNECT userX/new_password
execute dbms_job.run(1);

Go back to first session (user system) and restore userX old password:

ALTER USER userX IDENTIFIED BY VALUES '9F56C14116139736'; Received on Wed Apr 13 2005 - 13:45:32 CDT