DBMS_SCHEDULER.run_job
EmuFeb 24 2013 — edited Feb 27 2013Hi Guys,
I'm having a problem with using DBMS_SCHEDULER.
When I run with the current session set to true the job works, however when its not run as the current session (the same session that created the job) then it fails to execute. (The package that seems to be the problem in on a remote database)
So I figure I need to give permissions on the problem package to um something. But um who do I grant the permisisons to?
begin
DBMS_SCHEDULER.run_job('myjob',use_current_session => true);
end;
works
begin
DBMS_SCHEDULER.run_job('myjob',use_current_session => false);
end;
fails