Advertisement
Guest User

Quartz.NET - list triggers with next fire time

a guest
Jan 22nd, 2016
263
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.19 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement