1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| -- 添加车辆里程统计定时任务（从GPS分段汇总）
| INSERT INTO sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark)
| VALUES (
| (SELECT IFNULL(MAX(job_id), 0) + 1 FROM sys_job t),
| '车辆里程统计任务（从分段汇总）',
| 'DEFAULT',
| 'vehicleMileageStatsTask.aggregateYesterdayFromSegments',
| '0 30 1 * * ?',
| '3',
| '1',
| '1',
| 'admin',
| NOW(),
| '',
| NULL,
| '每天凌晨1:30执行，从GPS分段里程汇总生成昨日统计数据（推荐方式，性能更好）'
| );
|
|
