scheduling_setup.sql

Java的框架

USE PRRM;
--
-- Dumping data for table `prrm`.`qrtz_job_details`
--

INSERT INTO `qrtz_job_details` (`JOB_NAME`,`JOB_GROUP`,`DESCRIPTION`,`JOB_CLASS_NAME`,`IS_DURABLE`,`IS_VOLATILE`,`IS_STATEFUL`,`REQUESTS_RECOVERY`,`JOB_DATA`) VALUES 
 ('SendEmailJob','SYSTEM_JOB','Send Email Job.','mcap.core.scheduling.job.SendEmailJob','1','0','0','1',0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB0200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000005740002436374000074000342636371007E00077400075375626A65637474001C4D6573736167652046726F6D2053656E6420456D61696C20204A6F62740002546F74001661646D696E40636170646576656C6F7065722E636F6D7400074D65737361676571007E00077800),
 ('UnackAlertJob','SYSTEM_JOB','Job to check for unacknowledged alert and notify the user if any unacknowlegded alert is found.','mcap.core.alert.job.UnacknowlegdedAlertJob','1','0','0','1',0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB0200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000E556E61636B5468726573686F6C6474000536303030307800);

--
-- Dumping data for table `prrm`.`qrtz_triggers`
--

INSERT INTO `qrtz_triggers` (`TRIGGER_NAME`,`TRIGGER_GROUP`,`JOB_NAME`,`JOB_GROUP`,`IS_VOLATILE`,`DESCRIPTION`,`NEXT_FIRE_TIME`,`PREV_FIRE_TIME`,`TRIGGER_STATE`,`TRIGGER_TYPE`,`START_TIME`,`END_TIME`,`CALENDAR_NAME`,`MISFIRE_INSTR`,`JOB_DATA`) VALUES 
 ('UnackAlertSchedule','SYSTEM_SCHEDULE','UnackAlertJob','SYSTEM_JOB','0','',1151467200000,1151380800000,'WAITING','SIMPLE',1141272000000,0,NULL,0,0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB0200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000E556E61636B5468726573686F6C6474000538303030307800);

--
-- Dumping data for table `prrm`.`qrtz_simple_triggers`
--

INSERT INTO `qrtz_simple_triggers` (`TRIGGER_NAME`,`TRIGGER_GROUP`,`REPEAT_COUNT`,`REPEAT_INTERVAL`,`TIMES_TRIGGERED`) VALUES 
 ('UnackAlertSchedule','SYSTEM_SCHEDULE',-1,86400000,1);