Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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