34 lines
1.1 KiB
SQL
34 lines
1.1 KiB
SQL
-- 为已执行 20260831 表迁移的环境补登记企微推广自动化补偿任务。
|
|
|
|
START TRANSACTION;
|
|
|
|
INSERT INTO `zyt_dev_crontab` (
|
|
`name`, `type`, `system`, `remark`, `command`, `params`,
|
|
`status`, `expression`, `create_time`, `update_time`
|
|
)
|
|
SELECT
|
|
'补偿企微推广自动化', 1, 0,
|
|
'补偿客户标签、备注、成员记账、范围与客户资料同步，并清理过期欢迎码',
|
|
'qywx:retry-promotion-automation', '', 1, '* * * * *', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
|
FROM DUAL
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM `zyt_dev_crontab`
|
|
WHERE `command` = 'qywx:retry-promotion-automation' AND `delete_time` IS NULL
|
|
);
|
|
|
|
INSERT INTO `zyt_dev_crontab` (
|
|
`name`, `type`, `system`, `remark`, `command`, `params`,
|
|
`status`, `expression`, `create_time`, `update_time`
|
|
)
|
|
SELECT
|
|
'刷新企微推广欢迎语素材', 1, 0,
|
|
'预热并刷新渠道欢迎语使用的企业微信临时素材',
|
|
'qywx:refresh-promotion-media', '', 1, '*/5 * * * *', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
|
FROM DUAL
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM `zyt_dev_crontab`
|
|
WHERE `command` = 'qywx:refresh-promotion-media' AND `delete_time` IS NULL
|
|
);
|
|
|
|
COMMIT;
|