10-10-2022 10:08 AM
Hi All,
Is there a way to retrieve all the schema load schedules with details in a tenant?
Version - 5.1.4
Thanks,
Srinivas
10-17-2022 04:35 AM
Hi Srini,
Please Try the following query using Incorta metadata DB:
SELECT
A.NAME AS "Schema_Name",
B."NAME" AS "Job_Name",
B.DESCRIPTION AS "Description"
FROM
_IncortaMetadata.SCHEMA A
JOIN _IncortaMetadata.SCHEDULER_JOB B ON A.ID = B.ENTITYID
WHERE
(B.JOBTYPE = 1)
And B.ENTITYTYPE = 5
10-19-2022 09:14 AM
Hi Rasha,
The above query will only help us retrieve the Job Names by schema. But we would like to know the details (similar to Schedule Screen - Like timings, Load Type, Days etc) of the schedule of each job.
Thanks,
Srini
11-11-2022 10:52 AM
Hi,
Is there any update on this request?
Thanks,
Srini
11-13-2022 09:44 AM
Hi @srini_ch -
QRTZ_TRIGGERS QRTZ_SIMPROP_TRIGGERS
string( _IncortaMetadata.SCHEDULER_JOB.ID )
SCHEDULER_JOB.ID_String ------> QRTZ_TRIGGERS.TRIGGER_NAME SCHEDULER_JOB.OWNERID -----> USER.ID