Oracle 定时任务创建 表备份

BEGIN
    DBMS_SCHEDULER.CREATE_JOB (
        job_name        => 'AW_001_000002_000001_BACKUP_JOB',
        job_type        => 'PLSQL_BLOCK',
        job_action      => 'BEGIN 
        /*删除30天之前的数据*/
  delete from XXX_BACKUP t where 1=1 and t.backup_date<trunc(sysdate)-30;
  /*备份现有数据，每天备份一次*/
  insert into XXX_BACKUP
    select t.*, sysdate as backup_date from XXX t; END;', -- 直接指定PL/SQL块
        start_date      => to_date('29-05-2024 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
        repeat_interval => 'Freq=Daily;Interval=1',
        end_date        => NULL,
        enabled         => TRUE,
        comments        => 'xxx每日备份定时任务 '
    );
END;
/