dbms_scheduler
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