Which table has the job cron schedule

[Mareetta]

Could someone please guide here? which table has the scheduled job cron expression? Not the last run or next run but the schedule that we have put in (say, every 30 mins, every 1 day at 2 pm or the cron)

[RakeshMG]

Currently the requested details are not available on UI for access.

Following tables are available from UI to access.

qrtz_triggers Table

qrtz_job_details Table

qrtz_fired_triggers Table

https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...

An enhancement request has been raised for same : https://ideas.saviynt.com/ideas/EIC-I-4322.
Request you to reach to CSM to get the enhancement request prioritized. 

[Mareetta]

It says no record found for EIC-I-4322

[Darshanjain · Accepted solution]

Hi @Mareetta 

It is stored in qrtz_cron_triggers however you will not be able to view it in Data analyzer, you can check in analytics.

select TRIGGER_GROUP,TRIGGER_NAME,CRON_EXPRESSION from qrtz_cron_triggers;

Thanks

Darshan

[sk · Accepted solution]

You can find that information in qrtz_cron_triggers table under column cron_experssion.

But Qrtz tables are not visible/accessible from Data Analyzer you need to run it from analytics

[Mareetta]

Thank you @sk @Darshanjain