达梦数据库作业相关SQL

--查看数据库已启用的所有作业
SELECT * FROM SYSJOB.SYSJOBS WHERE ENABLE=1;

--批量禁用达梦数据库所有作业
SELECT 'CALL SP_ALTER_JOB('''||SJ.NAME||''',0,'||SJ.ENABLE_EMAIL||','''','||SJ.EMAIL_TYPE||','||SJ.ENABLE_NETSEND||','''','||SJ.NETSEND_TYPE||','''||SJ.DESCRIBE||''');'FROM SYSJOB.SYSJOBS SJ WHERE SJ.ENABLE=1;

--批量启用达梦数据库所有作业
SELECT 'CALL SP_ALTER_JOB('''||SJ.NAME||''',1,'||SJ.ENABLE_EMAIL||','''','||SJ.EMAIL_TYPE||','||SJ.ENABLE_NETSEND||','''','||SJ.NETSEND_TYPE||','''||SJ.DESCRIBE||''');'FROM SYSJOB.SYSJOBS SJ WHERE SJ.ENABLE=0;

--查看达梦数据库备份作业信息
SELECT
SJ."NAME" "作业名称" ,
(CASE SJS."TYPE" WHEN 0 THEN '执行SQL语句' WHEN 1 THEN '数据库备份' WHEN 5 THEN '数据库备份' WHEN 6 THEN '数据库备份' ELSE '其他步骤' END)"步骤类型" ,
SJ."DESCRIBE" "作业描述信息" ,
(CASE SJC."TYPE" WHEN 0 THEN '只执行一次' WHEN '1' THEN '每天执行' WHEN '2' THEN '每周执行' WHEN '3' THEN '每天执行' ELSE '其他类型' END)"调度类型" ,
(CASE SJC."FREQ_MINUTE_INTERVAL" WHEN 0 THEN '只执行一次' END)"调度执行间隔(分钟)",
SJC."STARTTIME" "调度起始时间" ,
SJC."DURING_START_DATE" "调度起始日期" ,
SJS."DBNAME" "所属数据库"
FROM
"SYSJOB"."SYSJOBSCHEDULES" SJC,
"SYSJOB"."SYSJOBS" SJ ,
"SYSJOB"."SYSJOBSTEPS" SJS
WHERE
SJC."ENABLE" =1
AND SJC."VALID" ='Y'
AND SJ."ENABLE" =1
AND SJ."VALID" ='Y'
AND SJS."JOBID" =SJ."ID"
AND SJC."JOBID" =SJ."ID";