Database Administration (MOSC)

MOSC Banner

How to create job with another owner in dbms_scheduler

Hi everyone,

I am connected as sys and I don't have password for another schema_a, so I cannot connect to schema_a directly to do dbms_scheduler.create_job.

Is it possible to run dbms_scheduler,create_job under sys, but the owner of the job is schema_a and how?

Please shed some light on it.

Thxs

friendly

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center