"Next Run" values while creating reports that show Schedule Jobs

Issue Description

A customer wants to create a report which shows the "next run" values for Schedule jobs, but they're having trouble finding the values

Resolution

The fields prev_fire_time and next_fire_time in qrtz_triggers table are the fields which show the "previous" and "next" runs times.

Note that these are EPOCH dates.

For better readability you could use a derived table via a domain. You'd write a query to perform your formatting to return a string or a java.sql.Timestamp, etc from EPOCH. At runtime the query will be dumped inline into the main query that is generated by the domain layers.

See: http://community.jaspersoft.com/documentation/tibco-jasperreports-server-user-guide/v640/derived-tables-tab

Ref. Case 01527535