DM数据库JOB配置手顺

最新推荐文章于 2023-11-12 15:16:57 发布

weixin_43455738

最新推荐文章于 2023-11-12 15:16:57 发布

阅读量252

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/weixin_43455738/article/details/110284811

版权

初始化环境 SP_INIT_JOB_SYS(1);

创建操作员：sp_create_operator(‘opr1’,1,’’,‘1.1.1.1’);
–查看：select * from sysjob.sysoperators;
–修改操作员:sp_alter_operator(‘opr1’,1,‘opr1@dm.com’,‘1.1.1.2’);

创建作业
sp_create_job(‘backup_database’,1,0,‘opr1’,0,0,‘opr1’,0,‘test job’);
–删除 sp_drop_job(‘backup_database’);
–查看 select * from sysjob.sysjobs;

开始配置作业
sp_job_config_start(‘backup_database’);

增加作业步骤 sp_add_job_step(‘backup_database’,‘step1’,6,‘00010000/opt/dmdbms/data/middb/bak’,0,2,0,0,null,0);
–删除 sp_drop_job_step(‘backup_database’,‘step1’);
–查看 select * from sysjob.sysjobsteps;

增加调度
sp_add_job_schedule(‘backup_database’,‘bak_schedule1’,1,1,1,0,1,CURTIME,NULL,CURDATE,NULL,‘test_backup’);
–删除 sp_drop_job_schedule(‘backup_database’,‘bak_schedule1’);
–查看 select * from sysjob.sysjobschedules;
结束作业配置
SP_JOB_CONFIG_COMMIT(‘backup_database’);