and more in a single search tool across platforms. Read the announcement here. |
03/10/2023 12:55 AM
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)
Solved! Go to Solution.
03/10/2023 01:51 AM
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
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.
03/10/2023 02:23 AM
It says no record found for EIC-I-4322
03/10/2023 02:28 AM - edited 03/10/2023 02:38 AM
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
03/10/2023 07:40 AM
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
03/15/2023 04:47 AM
Thank you @sk @Darshanjain