How To Find The Name Of The Trigger Name Based On The Quartz Table?

News Knowledge Base
1

How to find the name of the Trigger name based on the Quartz table?

To find the Trigger names:

  1. Get the folder ID for the folder where the triggers are present,

image.png

  1. Go to Swagger or Postman and run the following API call with the folder ID in the headers:https://orchestrator.local/odata/ProcessSchedules
  2. The results returned will contain a ExternalJobKey (1 and 2)
  3. The value (3) is the trigger name found in the table quartz.triggers :

  1. If there are trigger issues, recreate the triggers returned as Error on the below script:

select TRIGGER_NAME

,JOB_NAME

,TRIGGER_STATE

,PREV_FIRE_TIME

,CAST(PREV_FIRE_TIME / 864000000000.0 - 693595.0 as datetime) Previous

,NEXT_FIRE_TIME

,CAST(NEXT_FIRE_TIME / 864000000000.0 - 693595.0 as datetime) Next

,case

when (CAST(PREV_FIRE_TIME / 864000000000.0 - 693595.0 as datetime) < CAST(NEXT_FIRE_TIME / 864000000000.0 - 693595.0 as datetime))

--and (CAST(PREV_FIRE_TIME / 864000000000.0 - 693595.0 as datetime) < dateadd (HOUR,-2,GETDATE()))

--and (CAST(NEXT_FIRE_TIME / 864000000000.0 - 693595.0 as datetime) > dateadd (hour,-2,GETDATE()))

then 'Good'

else 'Error'

end

from quartz.QRTZ_TRIGGERS