DM达梦数据库周期性备份脚本

--周日全备
call SP_CREATE_JOB( 'back_up_db_full',1,0,'',0,0,'',0,'');
call SP_JOB_CONFIG_START('back_up_db_full');
call SP_ADD_JOB_STEP('back_up_db_full', 'back_up_full_on_sunday', 5, '01000E:\dbdata\DAMENG\bak', 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE('back_up_db_full', 'back_full_once_a_week', 1, 2, 1, 1, 0, '20:20:20', NULL, '2019-11-08 16:20:41', NULL, '');
call SP_JOB_CONFIG_COMMIT('back_up_db_full');

--周一至周六增备
call SP_CREATE_JOB('back_up_db_incr',1,0,'',0,0,'',0,'');
call SP_JOB_CONFIG_START('back_up_db_incr');
call SP_ADD_JOB_STEP('back_up_db_incr', 'back_db_inc_days', 5, '11100E:\dbdata\DAMENG\bak|E:\dbdata\DAMENG\bak', 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE('back_up_db_incr', 'once_a_day', 1, 2, 1, 126, 0, '20:20:20', NULL, '2019-11-08 16:22:28', NULL, '');
call SP_JOB_CONFIG_COMMIT('back_up_db_incr');