DM数据库定时清楚归档日志:
每天02:00删除15天前的归档日志
call SP_CREATE_JOB(‘arch_delete’,1,0,‘’,0,0,‘’,0,‘删除15天前的归档’);
call SP_JOB_CONFIG_START(‘arch_delete’);
call SP_ADD_JOB_STEP(‘arch_delete’, ‘DELETE_BEFORE’, 0, ‘CALL SF_ARCHIVELOG_DELETE_BEFORE_TIME(SYSDATE-15);’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘arch_delete’, ‘DELETE_TIME’, 1, 1, 1, 0, 0, ‘02:00:01’, NULL, ‘2019-12-20 22:59:13’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘arch_delete’);
更多资讯请上:https://eco.dameng.com