call SP_CREATE_JOB('full_del_bak',1,0,'',0,0,'',0,'每周日全量备份，备份成功后执行删除备份作业');

call SP_JOB_CONFIG_START('full_del_bak');

call SP_ADD_JOB_STEP_EX('full_del_bak', 'full_bak', 6, '02000000/dmbak', 3, 1, 0, 0, NULL, 0, '');

call SP_ADD_JOB_STEP_EX('full_del_bak', 'del_bak', 0, 'call SF_BAKSET_BACKUP_DIR_ADD(''DISK'',''/dmbak'');
call SP_DB_BAKSET_REMOVE_BATCH(''DISK'', SYSDATE()-20);', 1, 1, 0, 0, NULL, 0, '');

call SP_ADD_JOB_SCHEDULE('full_del_bak', 'exe_full_del_bak', 1, 2, 1, 1, 0, '21:00:00', NULL, '2023-08-07 10:32:31', NULL, '');

call SP_ADD_JOB_SCHEDULE('full_del_bak', 'test_full_del_bak', 1, 0, 0, 0, 0, NULL, NULL, '2024-07-15 16:18:36', NULL, '');

call SP_JOB_CONFIG_COMMIT('full_del_bak');

call SP_JOB_SET_SCHEMA('full_del_bak', 'SYSDBA');




call SP_CREATE_JOB('incr_bak',1,0,'',0,0,'',0,'周一至周六增备，增备失败执行全备');

call SP_JOB_CONFIG_START('incr_bak');

call SP_ADD_JOB_STEP_EX('incr_bak', 'incr_bak', 6, '12000000/dmbak|/dmbak', 1, 3, 0, 0, NULL, 0, '');

call SP_ADD_JOB_STEP_EX('incr_bak', 'full_bak', 6, '02000000/dmbak', 1, 1, 0, 0, NULL, 0, '');

call SP_ADD_JOB_SCHEDULE('incr_bak', 'exe_incr_bak', 1, 2, 1, 126, 0, '21:00:00', NULL, '2023-08-07 10:41:17', NULL, '');

call SP_JOB_CONFIG_COMMIT('incr_bak');

call SP_JOB_SET_SCHEMA('incr_bak', 'SYSDBA');