Job schedule report

[NPY]

Hi,

I need to generate a report of the current schedules of all the jobs. I can generate this using qrtz_cron_triggers table but apparently the table provides schedules in cron expression. Is there a way (possibly using other tables) to generate this report with the schedule output in a human readable format instead of cron expression?

Thank you

[dgandhi]

There is no Out of the box way to generate the report.

[KG]

Hi NPY,

I need to generate a report of the current schedules of all the jobs and I need subset and trigger order  of jobs running in trigger chain with their schedule.Please help me out?

[dgandhi]

you can get the information about cron expression from qrtz_triggers table. Please check that.

[tmoran]

NPY & KG,

I need to generate a report of the current jobs and trigger chains as well.  Is there an out of the box way or does this have to go to "new feature" request?

[rushikeshvartak]

Use control center -Service Health  - Monitor - Scheduled Jobs

Query :

SELECT TRIGGER_NAME AS 'Job Trigger Name', JOB_GROUP, TRIGGER_STATE, FROM_UNIXTIME(t.NEXT_FIRE_TIME / 1000) AS 'Next Trigger Date', WEEK(FROM_UNIXTIME(t.NEXT_FIRE_TIME / 1000)) AS 'Next Trigger Week', COUNT(*) AS 'Trigger Count' FROM qrtz_triggers t WHERE t.NEXT_FIRE_TIME != 4070945700000 AND FROM_UNIXTIME(t.NEXT_FIRE_TIME / 1000) > SYSDATE() GROUP BY TRIGGER_NAME ,JOB_GROUP,TRIGGER_STATE, 'NextTrigger Date' , 'Next Trigger Week';