How To get a Overview of all Schedules ?

[qs2002]

Hello, i am just a new Friend of JasperServer,

a question, because after searching 2 hours i found no answer:

 

how can i get a list or overview from all active schedules ?

i can see an overview of the reports, of the report-outputs,

but not from all schedules, wich were assigned to several reports.

 

if there is no way in jasperserver, are there alternative ways ?

 

- in iReport which jasperserver-plugin ? - but how to ?

- via access to the mysql-database which drives jasperserver ? - but in which tables i have to look ?

 

many thanks for any help

thorsten

[ramnik]

1. First question, which verison of Jasperserver are u using ?

2. In Jasperserver3.7 and  Jasperserver3.7.1, we hvae search page, where you can do the filter setting to view all the scheduled jobs, reports schedules by me, Any schedule etc

 

see screen shot for more info

 

Ramnik Kaur

Senior QA Engineer

[qs2002]

dear mr. kaur, thanks again for replying to my problems

 

i use version 3.7.0.1, the schedule-filter options, you described, exists.

but there i can only choose, if reports are scheduled, not scheduled or scheduled by me.

 

i search a list-view, ordered by time, where i can have an overview

of all our scheduled reports.

 

this is necessary e.g. for finding time-slots which much or no traffic,

or for planing best times for system-work and planned timeouts.

 

if there are other possibilitys, also from other users, i am glad about it

best regards

thorsten

 

 

[qs2002]

hello all,

 

in fact of jasperserver didnt have such a important function,

i post now my solution.

 

jasperserver on its own stores all infos in his mysql-database.

so i build and report on this database,

added this report to jasperserver himself.

 

now i am able to have an overview about all schedules and their time order.

 

following i share the query for this report:

 

best regards

thorsten

 

 

----

 

SELECT
     jireportjob.`id` AS jireportjob_id,
     jireportjob.`label` AS jireportjob_label,
     jireportjob.`description` AS jireportjob_description,
     jireportjob.`job_trigger` AS jireportjob_job_trigger,
     jireportjob.`mail_notification` AS jireportjob_mail_notification,
     jireportjobtrigger.`start_type` AS jireportjobtrigger_start_type,
     jireportjobtrigger.`start_date` AS jireportjobtrigger_start_date,
     jireportjob.`report_unit_uri` AS jireportjob_report_unit_uri
FROM
     `jireportjobmail` jireportjobmail INNER JOIN `jireportjob` jireportjob ON jireportjobmail.`id` = jireportjob.`mail_notification`
     INNER JOIN `jireportjobtrigger` jireportjobtrigger ON jireportjob.`job_trigger` = jireportjobtrigger.`id`
ORDER BY     date_format(jireportjobtrigger.`start_date`, '%H:%i')

[Pawel.Hadam]

Hi - interesting query.

But I also wonder how we can see if a scheduler is running or PAUSED? On the web interface I can see a tick box, but I cannot find this information in any table. Any ideas where this information is stored?

I am using JasperReports Server Community ver 6.3.0. 

 

Thanks and regards

Pawel