Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TRIGGER_NAME
- ,NEXT_FIRE_TIME
- ,CAST(NEXT_FIRE_TIME / 864000000000.0 - 693595.0 AS DATETIME) + (GETDATE() - GETUTCDATE()) NEXT_FIRE_DATE
- FROM QRTZ_TRIGGERS
- ORDER BY TRIGGER_NAME
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement