HelloStranger

每个人都是初学者

Quartz JobStoreTx相关SQL

--  第 1 个
--  UPDATE_TRIGGER_STATES_FROM_OTHER_STATES : 
UPDATE 
	QRTZ_TRIGGERS 
SET 
	TRIGGER_STATE = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	(
		TRIGGER_STATE = ? OR 
		TRIGGER_STATE = ?
	)

--  第 2 个
--  SELECT_MISFIRED_TRIGGERS : 
SELECT 
	* 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	NOT (MISFIRE_INSTR = -1) AND 
	NEXT_FIRE_TIME < ? 
ORDER BY 
	NEXT_FIRE_TIME ASC, 
	PRIORITY DESC

--  第 3 个
--  SELECT_TRIGGERS_IN_STATE : 
SELECT 
	TRIGGER_NAME, 
	TRIGGER_GROUP 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler 
	AND TRIGGER_STATE = ?

--  第 4 个
--  SELECT_MISFIRED_TRIGGERS_IN_STATE : 
SELECT 
	TRIGGER_NAME, 
	TRIGGER_GROUP 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	NOT (MISFIRE_INSTR = -1) AND 
	NEXT_FIRE_TIME < ? AND 
	TRIGGER_STATE = ? 
ORDER BY 
	NEXT_FIRE_TIME ASC, 
	PRIORITY DESC

--  第 5 个
--  COUNT_MISFIRED_TRIGGERS_IN_STATE : 
SELECT 
	COUNT(TRIGGER_NAME) 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	NOT (MISFIRE_INSTR = -1) AND 
	NEXT_FIRE_TIME < ? AND 
	TRIGGER_STATE = ?

--  第 6 个
--  SELECT_HAS_MISFIRED_TRIGGERS_IN_STATE : 
SELECT 
	TRIGGER_NAME, 
	TRIGGER_GROUP 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	NOT (MISFIRE_INSTR = -1) AND 
	NEXT_FIRE_TIME < ? AND 
	TRIGGER_STATE = ? 
ORDER BY 
	NEXT_FIRE_TIME ASC, 
	PRIORITY DESC

--  第 7 个
--  SELECT_MISFIRED_TRIGGERS_IN_GROUP_IN_STATE : 
SELECT 
	TRIGGER_NAME 
FROM 
    QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	NOT (MISFIRE_INSTR = -1) AND 
	NEXT_FIRE_TIME < ? AND 
	TRIGGER_GROUP = ? AND 
	TRIGGER_STATE = ? 
ORDER BY 
	NEXT_FIRE_TIME ASC, 
	PRIORITY DESC

--  第 8 个
--  DELETE_FIRED_TRIGGERS : 
DELETE FROM 
	QRTZ_FIRED_TRIGGERS 
WHERE SCHED_NAME = pipelineScheduler

--  第 9 个
--  INSERT_JOB_DETAIL : 
INSERT INTO QRTZ_JOB_DETAILS (
	SCHED_NAME, 
	JOB_NAME, 
	JOB_GROUP, 
	DESCRIPTION, 
	JOB_CLASS_NAME, 
	IS_DURABLE, 
	IS_NONCONCURRENT, 
	IS_UPDATE_DATA, 
	REQUESTS_RECOVERY, 
	JOB_DATA)  
VALUES(pipelineScheduler, ?, ?, ?, ?, ?, ?, ?, ?, ?)

--  第 10 个
--  UPDATE_JOB_DETAIL : 
UPDATE 
	QRTZ_JOB_DETAILS 
SET 
	DESCRIPTION = ?, 
	JOB_CLASS_NAME = ?, 
	IS_DURABLE = ?, 
	IS_NONCONCURRENT = ?, 
	IS_UPDATE_DATA = ?, 
	REQUESTS_RECOVERY = ?, 
	JOB_DATA = ?  
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 11 个
--  SELECT_TRIGGERS_FOR_JOB : 
SELECT 
	TRIGGER_NAME, 
	TRIGGER_GROUP 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 12 个
--  SELECT_TRIGGERS_FOR_CALENDAR : 
SELECT 
	TRIGGER_NAME, 
	TRIGGER_GROUP 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	CALENDAR_NAME = ?

--  第 13 个
--  DELETE_JOB_DETAIL : 
DELETE FROM 
	QRTZ_JOB_DETAILS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 14 个
--  SELECT_JOB_NONCONCURRENT : 
SELECT 
	IS_NONCONCURRENT 
FROM 
	QRTZ_JOB_DETAILS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 15 个
--  SELECT_JOB_EXISTENCE : 
SELECT 
	JOB_NAME 
FROM 
	QRTZ_JOB_DETAILS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 16 个
--  UPDATE_JOB_DATA : 
UPDATE 
	QRTZ_JOB_DETAILS 
SET 
	JOB_DATA = ?  
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 17 个
--  SELECT_JOB_DETAIL : 
SELECT 
	* 
FROM 
	QRTZ_JOB_DETAILS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 18 个
--  SELECT_NUM_JOBS : 
SELECT 
	COUNT(JOB_NAME)  
FROM 
	QRTZ_JOB_DETAILS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 19 个
--  SELECT_JOB_GROUPS : 
SELECT 
	DISTINCT(JOB_GROUP) 
FROM 
	QRTZ_JOB_DETAILS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 20 个
--  SELECT_JOBS_IN_GROUP_LIKE : 
SELECT 
	JOB_NAME, 
	JOB_GROUP 
FROM 
	QRTZ_JOB_DETAILS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_GROUP LIKE ?

--  第 21 个
--  SELECT_JOBS_IN_GROUP : 
SELECT 
	JOB_NAME, 
	JOB_GROUP 
FROM 
	QRTZ_JOB_DETAILS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_GROUP = ?

--  第 22 个
--  INSERT_TRIGGER : 
INSERT INTO QRTZ_TRIGGERS (
	SCHED_NAME, 
	TRIGGER_NAME, 
	TRIGGER_GROUP, 
	JOB_NAME, 
	JOB_GROUP, 
	DESCRIPTION, 
	NEXT_FIRE_TIME, 
	PREV_FIRE_TIME, 
	TRIGGER_STATE, 
	TRIGGER_TYPE, 
	START_TIME, 
	END_TIME, 
	CALENDAR_NAME, 
	MISFIRE_INSTR, 
	JOB_DATA, 
	PRIORITY)  
VALUES(pipelineScheduler, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

--  第 23 个
--  INSERT_SIMPLE_TRIGGER : 
INSERT INTO QRTZ_SIMPLE_TRIGGERS (
	SCHED_NAME, 
	TRIGGER_NAME, 
	TRIGGER_GROUP, 
	REPEAT_COUNT, 
	REPEAT_INTERVAL, 
	TIMES_TRIGGERED)  
VALUES(pipelineScheduler, ?, ?, ?, ?, ?)

--  第 24 个
--  INSERT_CRON_TRIGGER : 
INSERT INTO QRTZ_CRON_TRIGGERS (
	SCHED_NAME, 
	TRIGGER_NAME, 
	TRIGGER_GROUP, 
	CRON_EXPRESSION, 
	TIME_ZONE_ID)  
VALUES(pipelineScheduler, ?, ?, ?, ?)

--  第 25 个
--  INSERT_BLOB_TRIGGER : 
INSERT INTO QRTZ_BLOB_TRIGGERS (
	SCHED_NAME, 
	TRIGGER_NAME, 
	TRIGGER_GROUP, 
	BLOB_DATA)  
VALUES(pipelineScheduler, ?, ?, ?)

--  第 26 个
--  UPDATE_TRIGGER_SKIP_DATA : 
UPDATE 
	QRTZ_TRIGGERS 
SET 
	JOB_NAME = ?, 
	JOB_GROUP = ?, 
	DESCRIPTION = ?, 
	NEXT_FIRE_TIME = ?, 
	PREV_FIRE_TIME = ?, 
	TRIGGER_STATE = ?, 
	TRIGGER_TYPE = ?, 
	START_TIME = ?, 
	END_TIME = ?, 
	CALENDAR_NAME = ?, 
	MISFIRE_INSTR = ?, 
	PRIORITY = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 27 个
--  UPDATE_TRIGGER : 
UPDATE 
	QRTZ_TRIGGERS 
SET 
	JOB_NAME = ?, 
	JOB_GROUP = ?, 
	DESCRIPTION = ?, 
	NEXT_FIRE_TIME = ?, 
	PREV_FIRE_TIME = ?, 
	TRIGGER_STATE = ?, 
	TRIGGER_TYPE = ?, 
	START_TIME = ?, 
	END_TIME = ?, 
	CALENDAR_NAME = ?, 
	MISFIRE_INSTR = ?, 
	PRIORITY = ?, 
	JOB_DATA = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 28 个
--  UPDATE_SIMPLE_TRIGGER : 
UPDATE 
	QRTZ_SIMPLE_TRIGGERS 
SET 
	REPEAT_COUNT = ?, 
	REPEAT_INTERVAL = ?, 
	TIMES_TRIGGERED = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 29 个
--  UPDATE_CRON_TRIGGER : 
UPDATE 
	QRTZ_CRON_TRIGGERS 
SET 
	CRON_EXPRESSION = ?, 
	TIME_ZONE_ID = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 30 个
--  UPDATE_BLOB_TRIGGER : 
UPDATE 
	QRTZ_BLOB_TRIGGERS 
SET 
	BLOB_DATA = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 31 个
--  SELECT_TRIGGER_EXISTENCE : 
SELECT 
	TRIGGER_NAME 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 32 个
--  UPDATE_TRIGGER_STATE : 
UPDATE 
	QRTZ_TRIGGERS 
SET 
	TRIGGER_STATE = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 33 个
--  UPDATE_TRIGGER_STATE_FROM_STATE : 
UPDATE 
	QRTZ_TRIGGERS 
SET 
	TRIGGER_STATE = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ? AND 
	TRIGGER_STATE = ?

--  第 34 个
--  UPDATE_TRIGGER_GROUP_STATE_FROM_STATE : 
UPDATE 
	QRTZ_TRIGGERS 
SET 
	TRIGGER_STATE = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_GROUP LIKE ? AND 
	TRIGGER_STATE = ?

--  第 35 个
--  UPDATE_TRIGGER_STATE_FROM_STATES : 
UPDATE 
	QRTZ_TRIGGERS 
SET 
	TRIGGER_STATE = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ? AND 
	(	
		TRIGGER_STATE = ? OR 
		TRIGGER_STATE = ? OR 
		TRIGGER_STATE = ?
	)

--  第 36 个
--  UPDATE_TRIGGER_GROUP_STATE_FROM_STATES : 
UPDATE 
	QRTZ_TRIGGERS 
SET 
	TRIGGER_STATE = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_GROUP LIKE ? AND 
	(
		TRIGGER_STATE = ? OR 
		TRIGGER_STATE = ? OR 
		TRIGGER_STATE = ?
	)

--  第 37 个
--  UPDATE_JOB_TRIGGER_STATES : 
UPDATE 
	QRTZ_TRIGGERS 
SET 
	TRIGGER_STATE = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 38 个
--  UPDATE_JOB_TRIGGER_STATES_FROM_OTHER_STATE : 
UPDATE 
	QRTZ_TRIGGERS 
SET 
	TRIGGER_STATE = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ? AND 
	TRIGGER_STATE = ?

--  第 39 个
--  DELETE_SIMPLE_TRIGGER : 
DELETE FROM QRTZ_SIMPLE_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 40 个
--  DELETE_CRON_TRIGGER : 
DELETE FROM QRTZ_CRON_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 41 个
--  DELETE_BLOB_TRIGGER : 
DELETE FROM QRTZ_BLOB_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND TRIGGER_GROUP = ?

--  第 42 个
--  DELETE_TRIGGER : 
DELETE FROM QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 43 个
--  SELECT_NUM_TRIGGERS_FOR_JOB : 
SELECT 
	COUNT(TRIGGER_NAME) 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 44 个
--  SELECT_JOB_FOR_TRIGGER : 
SELECT 
	J.JOB_NAME, 
	J.JOB_GROUP, 
	J.IS_DURABLE, 
	J.JOB_CLASS_NAME, 
	J.REQUESTS_RECOVERY 
FROM 
	QRTZ_TRIGGERS T, 
	QRTZ_JOB_DETAILS J 
WHERE 
	T.SCHED_NAME = pipelineScheduler AND 
	J.SCHED_NAME = pipelineScheduler AND 
	T.TRIGGER_NAME = ? AND 
	T.TRIGGER_GROUP = ? AND 
	T.JOB_NAME = J.JOB_NAME AND 
	T.JOB_GROUP = J.JOB_GROUP

--  第 45 个
--  SELECT_TRIGGER : 
SELECT 
	* 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 46 个
--  SELECT_TRIGGER_DATA : 
SELECT 
	JOB_DATA 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 47 个
--  SELECT_TRIGGER_STATE : 
SELECT 
	TRIGGER_STATE 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 48 个
--  SELECT_TRIGGER_STATUS : 
SELECT 
	TRIGGER_STATE, 
	NEXT_FIRE_TIME, 
	JOB_NAME, 
	JOB_GROUP 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 49 个
--  SELECT_SIMPLE_TRIGGER : 
SELECT 
	* 
FROM 
	QRTZ_SIMPLE_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 50 个
--  SELECT_CRON_TRIGGER : 
SELECT 
	* 
FROM 
	QRTZ_CRON_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 51 个
--  SELECT_BLOB_TRIGGER : 
SELECT 
	* 
FROM 
	QRTZ_BLOB_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 52 个
--  SELECT_NUM_TRIGGERS : 
SELECT 
	COUNT(TRIGGER_NAME)  
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 53 个
--  SELECT_NUM_TRIGGERS_IN_GROUP : 
SELECT 
	COUNT(TRIGGER_NAME)  
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_GROUP = ?

--  第 54 个
--  SELECT_TRIGGER_GROUPS : 
SELECT 
	DISTINCT(TRIGGER_GROUP) 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 55 个
--  SELECT_TRIGGER_GROUPS_FILTERED : 
SELECT 
	DISTINCT(TRIGGER_GROUP) 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_GROUP LIKE ?

--  第 56 个
--  SELECT_TRIGGERS_IN_GROUP_LIKE : 
SELECT 
	TRIGGER_NAME, 
	TRIGGER_GROUP 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_GROUP LIKE ?

--  第 57 个
--  SELECT_TRIGGERS_IN_GROUP : 
SELECT 
	TRIGGER_NAME, 
	TRIGGER_GROUP 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_GROUP = ?

--  第 58 个
--  INSERT_CALENDAR : 
INSERT INTO QRTZ_CALENDARS (
	SCHED_NAME, 
	CALENDAR_NAME, 
	CALENDAR)  
VALUES(pipelineScheduler, ?, ?)

--  第 59 个
--  UPDATE_CALENDAR : 
UPDATE 
	QRTZ_CALENDARS 
SET 
	CALENDAR = ?  
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	CALENDAR_NAME = ?

--  第 60 个
--  SELECT_CALENDAR_EXISTENCE : 
SELECT 
	CALENDAR_NAME 
FROM 
	QRTZ_CALENDARS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	CALENDAR_NAME = ?

--  第 61 个
--  SELECT_CALENDAR : 
SELECT 
	* 
FROM 
	QRTZ_CALENDARS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	CALENDAR_NAME = ?

--  第 62 个
--  SELECT_REFERENCED_CALENDAR : 
SELECT 
	CALENDAR_NAME 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	CALENDAR_NAME = ?

--  第 63 个
--  DELETE_CALENDAR : 
DELETE FROM 
	QRTZ_CALENDARS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	CALENDAR_NAME = ?

--  第 64 个
--  SELECT_NUM_CALENDARS : 
SELECT 
	COUNT(CALENDAR_NAME)  
FROM 
	QRTZ_CALENDARS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 65 个
--  SELECT_CALENDARS : 
SELECT 
	CALENDAR_NAME 
FROM 
	QRTZ_CALENDARS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 66 个
--  SELECT_NEXT_FIRE_TIME : 
SELECT 
	MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_STATE = ? 
	AND NEXT_FIRE_TIME >= 0

--  第 67 个
--  SELECT_TRIGGER_FOR_FIRE_TIME : 
SELECT 
	TRIGGER_NAME, 
	TRIGGER_GROUP 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_STATE = ? AND 
	NEXT_FIRE_TIME = ?

--  第 68 个
--  SELECT_NEXT_TRIGGER_TO_ACQUIRE : 
SELECT 
	TRIGGER_NAME, 
	TRIGGER_GROUP, 
	NEXT_FIRE_TIME, 
	PRIORITY 
FROM 
	QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_STATE = ? AND 
	NEXT_FIRE_TIME <= ? AND 
	(
		MISFIRE_INSTR = -1 OR 
		(
			MISFIRE_INSTR != -1 AND 
			NEXT_FIRE_TIME >= ?
		)
	) 
ORDER BY 
	NEXT_FIRE_TIME ASC, 
	PRIORITY DESC

--  第 69 个
--  INSERT_FIRED_TRIGGER : 
INSERT INTO QRTZ_FIRED_TRIGGERS (
	SCHED_NAME, 
	ENTRY_ID, 
	TRIGGER_NAME, 
	TRIGGER_GROUP, 
	INSTANCE_NAME, 
	FIRED_TIME, 
	SCHED_TIME, 
	STATE, 
	JOB_NAME, 
	JOB_GROUP, 
	IS_NONCONCURRENT, 
	REQUESTS_RECOVERY, P
	RIORITY) 
VALUES(pipelineScheduler, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

--  第 70 个
--  UPDATE_FIRED_TRIGGER : 
UPDATE 
	QRTZ_FIRED_TRIGGERS 
SET 
	INSTANCE_NAME = ?, 
	FIRED_TIME = ?, 
	SCHED_TIME = ?, 
	STATE = ?, 
	JOB_NAME = ?, 
	JOB_GROUP = ?, 
	IS_NONCONCURRENT = ?, 
	REQUESTS_RECOVERY = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	ENTRY_ID = ?

--  第 71 个
--  SELECT_INSTANCES_FIRED_TRIGGERS : 
SELECT 
	* 
FROM 
	QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	INSTANCE_NAME = ?

--  第 72 个
--  SELECT_INSTANCES_RECOVERABLE_FIRED_TRIGGERS : 
SELECT 
	* 
FROM 
	QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	INSTANCE_NAME = ? AND 
	REQUESTS_RECOVERY = ?

--  第 73 个
--  SELECT_JOB_EXECUTION_COUNT : 
SELECT 
	COUNT(TRIGGER_NAME) 
FROM 
	QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 74 个
--  SELECT_FIRED_TRIGGERS : 
SELECT 
	* 
FROM 
	QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 75 个
--  SELECT_FIRED_TRIGGER : 
SELECT 
	* 
FROM 
	QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_NAME = ? AND 
	TRIGGER_GROUP = ?

--  第 76 个
--  SELECT_FIRED_TRIGGER_GROUP : 
SELECT 
	* 
FROM 
	QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_GROUP = ?

--  第 77 个
--  SELECT_FIRED_TRIGGERS_OF_JOB : 
SELECT 
	* 
FROM 
	QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_NAME = ? AND 
	JOB_GROUP = ?

--  第 78 个
--  SELECT_FIRED_TRIGGERS_OF_JOB_GROUP : 
SELECT 
	* 
FROM 
	QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	JOB_GROUP = ?

--  第 79 个
--  DELETE_FIRED_TRIGGER : 
DELETE FROM QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	ENTRY_ID = ?

--  第 80 个
--  DELETE_INSTANCES_FIRED_TRIGGERS : 
DELETE FROM QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	INSTANCE_NAME = ?

--  第 81 个
--  DELETE_NO_RECOVERY_FIRED_TRIGGERS : 
DELETE FROM QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	INSTANCE_NAME = ?REQUESTS_RECOVERY = ?

--  第 82 个
--  DELETE_ALL_SIMPLE_TRIGGERS : 
DELETE FROM QRTZ_SIMPLE_TRIGGERS  
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 83 个
--  DELETE_ALL_SIMPROP_TRIGGERS : 
DELETE FROM QRTZ_SIMPROP_TRIGGERS  
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 84 个
--  DELETE_ALL_CRON_TRIGGERS : 
DELETE FROM QRTZ_CRON_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 85 个
--  DELETE_ALL_BLOB_TRIGGERS : 
DELETE FROM QRTZ_BLOB_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 86 个
--  DELETE_ALL_TRIGGERS : 
DELETE FROM QRTZ_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 87 个
--  DELETE_ALL_JOB_DETAILS : 
DELETE FROM QRTZ_JOB_DETAILS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 88 个
--  DELETE_ALL_CALENDARS : 
DELETE FROM QRTZ_CALENDARS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 89 个
--  DELETE_ALL_PAUSED_TRIGGER_GRPS : 
DELETE FROM QRTZ_PAUSED_TRIGGER_GRPS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 90 个
--  SELECT_FIRED_TRIGGER_INSTANCE_NAMES : 
SELECT 
	DISTINCT INSTANCE_NAME 
FROM 
	QRTZ_FIRED_TRIGGERS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 91 个
--  INSERT_SCHEDULER_STATE : 
INSERT INTO QRTZ_SCHEDULER_STATE (
	SCHED_NAME, 
	INSTANCE_NAME, 
	LAST_CHECKIN_TIME, 
	CHECKIN_INTERVAL) 
VALUES(pipelineScheduler, ?, ?, ?)

--  第 92 个
--  SELECT_SCHEDULER_STATE : 
SELECT 
	* 
FROM 
	QRTZ_SCHEDULER_STATE 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	INSTANCE_NAME = ?

--  第 93 个
--  SELECT_SCHEDULER_STATES : 
SELECT 
	* 
FROM 
	QRTZ_SCHEDULER_STATE 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 94 个
--  DELETE_SCHEDULER_STATE : 
DELETE FROM QRTZ_SCHEDULER_STATE 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	INSTANCE_NAME = ?

--  第 95 个
--  UPDATE_SCHEDULER_STATE : 
UPDATE 
	QRTZ_SCHEDULER_STATE 
SET 
	LAST_CHECKIN_TIME = ? 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	INSTANCE_NAME = ?

--  第 96 个
--  INSERT_PAUSED_TRIGGER_GROUP : 
INSERT INTO QRTZ_PAUSED_TRIGGER_GRPS (
	SCHED_NAME, 
	TRIGGER_GROUP) 
VALUES(pipelineScheduler, ?)

--  第 97 个
--  SELECT_PAUSED_TRIGGER_GROUP : 
SELECT 
	TRIGGER_GROUP 
FROM 
	QRTZ_PAUSED_TRIGGER_GRPS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_GROUP = ?

--  第 98 个
--  SELECT_PAUSED_TRIGGER_GROUPS : 
SELECT 
	TRIGGER_GROUP 
FROM 
	QRTZ_PAUSED_TRIGGER_GRPS 
WHERE 
	SCHED_NAME = pipelineScheduler

--  第 99 个
--  DELETE_PAUSED_TRIGGER_GROUP : 
DELETE FROM QRTZ_PAUSED_TRIGGER_GRPS 
WHERE 
	SCHED_NAME = pipelineScheduler AND 
	TRIGGER_GROUP LIKE ?

--  第 100 个
--  DELETE_PAUSED_TRIGGER_GROUPS : 
DELETE FROM QRTZ_PAUSED_TRIGGER_GRPS 
WHERE 
	SCHED_NAME = pipelineScheduler
点赞

发表评论