任务
重要
描述
– ------------7月份数据调整(按机构处理 天津-13 ,河北-03, 四川-12，山西-11 ,内蒙-05,浙江-06,青岛-02 )
UPDATE dd_scheduling SET is_enable = 0 WHERE create_by = 'timed task' AND work_date >= '2023-07-01' AND work_date < '2023-08-01' AND org_branch_code in ('03','13','12','11','05','06','02');
– ------------7月份数据调整(中支机构 潍坊-0105 济南-0101 山东滨州-0112 山东莱芜-0119)
UPDATE dd_scheduling SET is_enable = 0 WHERE create_by = 'timed task' AND work_date >= '2023-07-01' AND work_date < '2023-08-01' AND org_middle_branch_code in ('0105','0101','0112','0119');
– -----------8月份数据调整(全量)--------生产8月份以后的数据已经执行过
UPDATE dd_scheduling SET is_enable = 0 WHERE create_by = 'timed task' AND work_date >= '2023-08-01' ;
