Re: How to execute another users job?

Caja wrote:
>
> Hello,
>
> I ran into the following problem:
> I have to run a job in a certain schema. I currently do not have the
> password for that schema but I can login as user SYSTEM or even SYS as
> sysdba.
> Is there any chance to run the users job with
> exec dbms_job.run(1)
> as user SYSTEM?
>
> Thanks for help or advice.
>
> Carsten

create procedure JOB_OWNER.RUN_JOB is
begin
  dbms_job.run(...)
end;

exec job_owner.run_job;

drop procedure JOB_OWNER.RUN_JOB ;

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------