cd /home/activeMQ/apache-activemq-5.15.9/bin/linux-x86-64
./activemq start
cd /home/nginx/sbin
./nginx
cd /home/redis/bin
./redis-server &
cd /home/zookeeper/zookeeper-3.4.8/bin
./zkServer.sh start
cd /home/emqx/emqx/bin
./emqx restart
qrtz_blob_triggers QRTZ_BLOB_TRIGGERS
qrtz_calendars QRTZ_CALENDARS
qrtz_cron_triggers QRTZ_CRON_TRIGGERS
qrtz_fired_triggers QRTZ_FIRDE_TRIGGERS
qrtz_job_details QRTZ_JOB_DETAILS
qrtz_locks QRTZ_LOCKS
qrtz_paused_trigger_grps QRTZ_PAUSED_TRIGGER_GRPS
qrtz_scheduler_state QRTZ_SCHEDULER_STATE
qrtz_simple_triggers QRTZ_SIMPLE_TRIGGERS
qrtz_simprop_triggers QRTZ_SIMPROP_TRIGGERS
qrtz_triggers QRTZ_TRIGGERS
0 1 0 * * ?
0 0 7-23/1 * * ?
0 0 1 1/1 * ?
0 20 0 * * ?
0 52 13 * * ?
select @@GLOBAL.sql_mode;
set @@sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
set @@GLOBAL.sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
set GLOBAL sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
flush privileges;
