Skip to Main Content

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!

DBMS_SCHEDULER.run_job

EmuFeb 24 2013 — edited Feb 27 2013
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2013
Added on Feb 24 2013
13 comments
2,990 views