Schedule Task: Job Mechanism - Oracle PL SQL Course - Lesson 37 | SQL courses

Duration: 16:10 min

Summary: Oracle has a job mechanism to schedule task that can be executed on a periodic basis. These jobs can be used to perform backups, index maintenance tasks, gather statistics, generate reports and AWR snapshots, import and export data and allocate data among other task. This video explains how to create a job in Oracle to be executed once using the procedures and functions of the DBMS_JOB package. Then the video shows how to check job information with the DBA_JOBS, DBA_JOBS_RUNNING and other views. Finally, the video shows how to create a recurring job using the routines of the DBMS_SCHEDULER package.