Query to list analytics name

[ant]

Hi,

Need help with query to list Analytics name and how long it had ran.

[ant]

something like this : 

[dgandhi]

Please try this:

select * from saviynt.ecmimportjob e where e.jobname= 'AnalyticsESJob'

[ant]

Hi,

Thank you for the suggestion close to what I'm looking for but I would want to output the exact Job name just as in Job control panel shown in screenshot :

For example. if I had created a job named "Entitlement_import" shown in screenshot below, is there a way or query that I can use to return/output just that instead of Jobtype or Category?

[dgandhi]

select * from saviynt.qrtz_triggers qt where qt.trigger_name like '%Entitlement_Import%'

Please use above query.