How to schedule jobs in Oracle Database: DBA_JOBS, DBA_SCHEDULER

Introduction We often want to run pre-defined jobs at different schedules. Oracle database provides dba_jobs/dbms_scheduler (Oracle Database job scheduler) for scheduling pre-defined jobs. Information about DBA_JOBS ( Till 9i) Query to see the jobs running through dba_jobs select /*+ rule */ * from dba_jobs_running; or select /*+ ordered */ * from dba_jobs_running; Common Reason why jobs …

How to schedule jobs in Oracle Database: DBA_JOBS, DBA_SCHEDULER Read More »