达梦创建作业相关流程

DECLARE
v_job_exists INT;
BEGIN
SELECT COUNT(*) INTO v_job_exists
FROM SYSJOB.SYSJOBS
WHERE NAME = 'JOB_AUTO_SETTLE_RPT';

IF v_job_exists > 0 THEN
CALL SP_DROP_JOB('JOB_AUTO_SETTLE_RPT');
DBMS_OUTPUT.PUT_LINE('作业 JOB_AUTO_SETTLE_RPT 已成功删除');
ELSE
DBMS_OUTPUT.PUT_LINE('作业 JOB_AUTO_SETTLE_RPT 不存在');
END IF;
END;
/

call SP_CREATE_JOB('JOB_AUTO_SETTLE_RPT',1,0,'',0,0,'',0,'每天凌晨2点定时结算所有报表');

call SP_JOB_CONFIG_START('JOB_AUTO_SETTLE_RPT');

call SP_JOB_SET_EP_SEQNO('JOB_AUTO_SETTLE_RPT', 0);

call SP_ADD_JOB_STEP('JOB_AUTO_SETTLE_RPT', 'auto_settle', 0, 'begin
call REPORT_SETTLE_ALL(to_char(sysdate-1,''YYYYMMDD''));
end;', 0, 0, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE('JOB_AUTO_SETTLE_RPT', 'AUTO_SCHEDULE', 1, 1, 1, 0, 0, '02:00:00', NULL,sysdate, NULL, 'auto_settle');

call SP_JOB_CONFIG_COMMIT('JOB_AUTO_SETTLE_RPT');