普元 EOS Platform 7.6 修改定时任务的执行时间，重启调度器报错：org.quartz.JobPersistenceException: Couldn't recover jobs: Proxy Warning - Syntax Forbidden

【问题】

EOS Platform 7.6 Mysql数据库，修改定时任务的执行时间，重启调度器报错：

[2017-11-16 13:59:45,781][INFO][org.quartz.core.QuartzSchedulerThread:213] -----$$$$$$$$$$$$$$$$$$$$$$-----Scheduler start run!-----$$$$$$$$$$$$$$$$$$$$$$-----
[2017-11-16 13:59:45,999][ERROR][com.primeton.common.connection.impl.synchronization.TraceLoggerStatementSynchronization:49] Sql[DELETE FROM EOS_QRTZ_FIRED_TRIGGERS] execute error.
java.sql.SQLException: Proxy Warning - Syntax Forbidden
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
 ......
[2017-11-16 13:59:46,112][ERROR][com.primeton.common.schedule.impl.SchedulerFacade:227] Scheduler startup error!
org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't recover jobs: Proxy Warning - Syntax Forbidden [See nested exception: java.sql.SQLException: Proxy Warning - Syntax Forbidden]]
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:512)
 at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:396)
 ......

【解答】

问题原因：项目里对Mysql数据库做了限制：设置了执行的SQL语句必须带有where条件

解决方式：可将已有的定时任务删除后，按新的调度时间重新添加，生产环境请谨慎操作