SHARE
TWEET

Quartz.NET - list triggers with next fire time

a guest Jan 22nd, 2016 76 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT TRIGGER_NAME
  2.   ,NEXT_FIRE_TIME
  3.   ,CAST(NEXT_FIRE_TIME / 864000000000.0 - 693595.0 AS DATETIME) + (GETDATE() - GETUTCDATE()) NEXT_FIRE_DATE
  4. FROM QRTZ_TRIGGERS
  5. ORDER BY TRIGGER_NAME
RAW Paste Data
Top