additional critera for report job execution

[scottward]

It would be very helpful if JS could provide for additional criteria when deciding that its time to run a report job. Currently, its based on time only.

 

However, I have numerous report jobs that need to run whenever there is new data in the database. However, the addition of new data is sporadic, not consistent. Currently, my only choice to keep the reports current is to run all the report jobs every night even though 90% of the time there is no change in output. Since these are complicated reports and take significant resources to run, that's not ideal.

 

It would be perfect if I could:

a) specify a query that returns a single value TRUE if new data is present and FALSE if not

b) schedule the report job to run every night BUT it will only execute if (a) is TRUE

 

So for example, I would write a query that compared the datetime the report was last fired and the latest modified date attached to the report data.

 

It would be really cool if the "last fired" value could be exposed in some kind of environment variable, but I could either grab it from the jasper database or create something of my own if I had to.

 

Does this make sense? Is there an existing way to accomplish this? Based on your feedback, I'll request the feature or not.

 

Scotty

[teodord]

Hello,

 

Could you post this as a feature request for the JasperServer product, so that we can track it better and eventually solve it?

http://jasperforge.org/sf/tracker/do/listArtifacts/projects.jasperintelligence/tracker.feature_requests

 

Thank you,

Teodor