| | |
| | | primary key (job_id, job_name, job_group) |
| | | ) engine=innodb auto_increment=4 comment = '定时任务调度表'; |
| | | |
| | | insert into sys_job values(1, '软件检测定时任务', 'DEFAULT', 'ryTask.runSoftTest', '0/10 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, ''); |
| | | insert into sys_job values(2, '分系统检测定时任务', 'DEFAULT', 'ryTask.runSubSysTest', '0/10 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, ''); |
| | | insert into sys_job values(1, '软件状态检测定时任务', 'DEFAULT', 'ryTask.runSoftTest', '0/10 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, ''); |
| | | insert into sys_job values(2, '系统状态检测定时任务', 'DEFAULT', 'ryTask.runSubSysTest', '0/10 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, ''); |
| | | -- insert into sys_job values(3, '系统默认(多参)', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, ''); |
| | | -- select * from sys_job order by job_id; |
| | | |