call SP_CREATE_JOB('del_bak',1,0,'',0,0,'',0,'');
call SP_JOB_CONFIG_START('del_bak');
call SP_ADD_JOB_STEP('del_bak', 'del_bak_step_1', 0, 'SF_BAKSET_BACKUP_DIR_ADD(''DISK'',''/var/dmdbms/data/bak'');CALL SP_DB_BAKSET_REMOVE_BATCH(''DISK'', NOW()-2);', 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE('del_bak', 'delete_before_data_bak', 1, 1, 1, 0, 0, '09:15:00', NULL, '2024-07-12 18:01:32', NULL, '');
call SP_JOB_CONFIG_COMMIT('del_bak');
感觉像这行前多了个回车的原因
--定时删除过期备份
在作业中建立脚本,脚本内容如下:
CALL SF_BAKSET_BACKUP_DIR_ADD('DISK','/var/dmdbms/data/bak');--在会话生效,每次必须增加备份集目录
CALL SF_BAKSET_REMOVE_BATCH ('DISK',now()-7,NULL,NULL);--now()为当前时间,指定删除7天前的备份
用上面的方式试试呢