-- 专家 expert_rating 每日 23:00 同步（需在「系统管理-定时任务」中启用）
-- 调用目标：expertRatingSyncTask.syncExpertRatings
-- 若 job_id 冲突请调整主键后执行

INSERT INTO sys_job (
    job_id, job_name, job_group, invoke_target, cron_expression,
    misfire_policy, concurrent, status, create_by, create_time, remark
) VALUES (
    100,
    '专家评分每日同步',
    'DEFAULT',
    'expertRatingSyncTask.syncExpertRatings',
    '0 0 23 * * ?',
    '3',
    '1',
    '0',
    'admin',
    sysdate(),
    '按预约评价重算 biz_tech_resource.expert_rating：(Σ到场准时+Σ服务态度+Σ指导效果)/3'
) ON DUPLICATE KEY UPDATE
    job_name = VALUES(job_name),
    invoke_target = VALUES(invoke_target),
    cron_expression = VALUES(cron_expression),
    remark = VALUES(remark);
