DBMS_JOB allows one to create/manage jobs under user who has logged but using sys.dbms_ijob one can manage jobs all jobs scheduled in DBA_JOBS. Here are some of the functions available in sys.dbms_ijob. To execute/run job: You don't have to be an owner of the job SQL> exec sys.dbms_ijob.run(5); If one tried executing the job not … Continue reading Using sys.dbms_iob one can manage jobs in dba_jobs. →