Database Administration (MOSC)

MOSC Banner

dbms_scheduler

edited Jan 15, 2010 2:28AM in Database Administration (MOSC) 1 commentAnswered
 Hi

I created a job for an user ABC using dbms_scheduler. The job was created by SYS in ABC schema.

While the following statement shows the owner as ABC,

SELECT JOB_NAME, STATE, OWNER FROM DBA_SCHEDULER_JOBS;

SELECT JOB_NAME, STATE, OWNER FROM DBA_SCHEDULER_JOBS;

whenever the job runs, the OEM shows the username as SYS. Is this the usual behaviour? I have just moved the jobs from dbms_jobs to dbms_scheduler. Any tips will be helpful.

Regards

KLA

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