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:
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' |
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' |
I hereby claim:
To claim this, I am signing this object: