sql/vehicle_mileage_stats_job.sql
@@ -0,0 +1,17 @@ -- 添加车辆里程统计定时任务 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.calculateYesterdayMileage', '0 30 1 * * ?', '3', '1', '0', 'admin', NOW(), '', NULL, '每天凌晨1:30执行,统计昨日所有车辆的行驶里程' );