dthongmtl

SELECT T.JOB_NAME, 
FROM_UNIXTIME(T.NEXT_FIRE_TIME/1000, GET_FORMAT(DATETIME,'ISO')) NEXT_FIRE, 
FROM_UNIXTIME(T.PREV_FIRE_TIME/1000, GET_FORMAT(DATETIME,'ISO')) PREV_FIRE, 
T.TRIGGER_STATE, 
FROM_UNIXTIME(T.START_TIME/1000, GET_FORMAT(DATETIME,'ISO')) START_JOB, 
CASE T.TRIGGER_TYPE
	WHEN 'SIMPLE' THEN 
		CASE T.MISFIRE_INSTR
			WHEN -1 THEN 'IGNORE_MISFIRE_POLICY'
			WHEN 1 THEN 'FIRE_NOW'

dthongmtl

Keybase proof

I hereby claim:

• I am dthongmtl on github.
• I am dthong (https://keybase.io/dthong) on keybase.
• I have a public key ASCaqjpb9oE_dR1n15u7Q9f4FnXsclxpbvdELl6BLmy_FAo

To claim this, I am signing this object:

dthongmtl

SELECT p.id, CASE p.method_id 
	WHEN 1 THEN 'MANUAL'
	WHEN 2 THEN 'VISA'
	WHEN 3 THEN 'MASTERCARD'
	WHEN 4 THEN 'AMEX'
	WHEN 6 THEN 'DISCOVER'
	WHEN 8 THEN 'PAYPAL'
	WHEN 9 THEN 'GATEWAY'
	WHEN 100 THEN 'CUSTOM'
	WHEN 101 THEN 'DTAG'