This discussion is archived
1 Reply Latest reply: Oct 24, 2012 7:48 AM by spajdy RSS

Oracle Scheduler - Which user runs the job?

stuart_barber Newbie
Currently Being Moderated
Hi

We are in the process of migrating all our old DBMS_JOBs to the Scheduler. We have one admin user who has the privilege to create any job. Let's call him "User A".

When a job is created for "User B" bu "User A" the job appears with the "User B" schema as expected. The Job Creator is set "User A".

When the job runs as a background task (i.e. by the scheduler) it runs as "User A" as a DBLINK connect fails.

Is there anyway to make the job run as the user who OWNS the job and not as the user who CREATED the job?

Thanks for your help.

Stuart

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points