清除作业列表SQL-白红宇

清除作业列表SQL

阅读量：5030 次

发布时间：2019-06-12

本文共 606 字，大约阅读时间需要 2 分钟。

DELETE CM_JOB_SRC_LOGWHERE job_id IN (select job_id from CM_JOB_LOG where job_status = '2000' and job_id in('20150919000114'));delete CM_JOB_STEP_LOGwhere job_id in(select job_id from CM_JOB_LOG where job_status = '2000' and job_id in('20150919000114'));DELETE CM_JOB_STAT_LOGWHERE job_id IN (select job_id from CM_JOB_LOG where job_status = '2000' and job_id in('20150919000114'));DELETE CM_JOB_LOGWHERE job_status = '2000' and job_status = '2000' and job_id IN('20150919000114');/* (job_status)1000    正在执行中2000    成功完成3000    重启作业4000    取消作业9000    失败*/

转载于:https://www.cnblogs.com/arcer/p/4828823.html

你可能感兴趣的文章

CF717A Festival Organization（第一类斯特林数，斐波那契数列）

查看>>

oracle直接读写ms sqlserver数据库（二）配置透明网关

查看>>

控件发布：div2dropdownlist(div模拟dropdownlist控件)

查看>>

Oracle composite index column ordering

查看>>

ActiveReports 报表控件官方中文入门教程 (3)-如何选择页面报表和区域报表

查看>>