Oracle SQL & PL/SQL

  In Oracle Database, DBMS_SCHEDULER is a powerful built-in PL/SQL package used to schedule, automate, execute, and monitor database tasks along with manage background task inside the Oracle Database. It is especially useful for DBAs who need to automate routine maintenance, data processing, backups, reporting, and other recurring activities. 1. What is DBMS_SCHEDULER and it's use. DBMS_SCHEDULER is an Oracle-supplied PL/SQL package that allows database users and administrators to define and manage scheduled jobs. For example, suppose a DBA needs to run a table cleanup procedure every day at 2:00 AM. Instead of manually executing the procedure, the DBA can create a scheduler job that runs automatically. Automating data loads, transformations and clean up from staging tables into core datawarehouse tables.  Data purging activities Report scheduling