Do we have any table to list our Schedule jobs and their run status?

[Priyadharsini]

Do we have any table to list our Schedule jobs and their run status?

[NM]

Hi @Priyadharsini , ecmimportjob table will provide you with the details.

[Raghu]

@Priyadharsini  try below query in reports and run it

select
  a.ANALYTICSNAME,
  a.CREATEDATE 'Created On',
  a.LASTRUN 'Report previous Run',
  qt.TRIGGER_NAME 'Job Name',
  qct.CRON_EXPRESSION,
  FROM_UNIXTIME(qt.NEXT_FIRE_TIME/1000) 'Job next fire time',
  FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000) 'Job previous fire time',
  case
    when FROM_UNIXTIME(qt.Next_FIRE_TIME/1000) > now()=1 and date(FROM_UNIXTIME(qt.Next_FIRE_TIME/1000))=date(now()) then 'Yet to run'
    when date(a.lastrun)=date(FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000)) and date(FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000))=date(now()) then 'Report ran successful as scheduled'
    when date(a.lastrun)!=date(FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000)) and date(FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000))=date(now()) then 'Report run mismatch'
  end as 'Report run status',
  a.METADATA 'Run summary details'
from
  analyticsconfiges a, qrtz_triggers qt, qrtz_cron_triggers qct
where
  qt.TRIGGER_NAME=concat('Analytics_',a.ANALYTICSKEY,'CRONE')
  and qt.TRIGGER_NAME=qct.TRIGGER_NAME

[rushikeshvartak]

• qrtz_triggers trigger stores all job related information
• This table is exposed from analytics and not from data analyzer 
• For Report use below query 

select
  a.ANALYTICSNAME,
  a.CREATEDATE 'Created On',
  a.LASTRUN 'Report previous Run',
  qt.TRIGGER_NAME 'Job Name',
  qct.CRON_EXPRESSION,
  FROM_UNIXTIME(qt.NEXT_FIRE_TIME/1000) 'Job next fire time',
  FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000) 'Job previous fire time',
  case
    when FROM_UNIXTIME(qt.Next_FIRE_TIME/1000) > now()=1 and date(FROM_UNIXTIME(qt.Next_FIRE_TIME/1000))=date(now()) then 'Yet to run'
    when date(a.lastrun)=date(FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000)) and date(FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000))=date(now()) then 'Report ran successful as scheduled'
    when date(a.lastrun)!=date(FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000)) and date(FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000))=date(now()) then 'Report run mismatch'
  end as 'Report run status',
  a.METADATA 'Run summary details'
from
  analyticsconfiges a, qrtz_triggers qt, qrtz_cron_triggers qct
where
  qt.TRIGGER_NAME=concat('Analytics_',a.ANALYTICSKEY,'CRONE')
  and qt.TRIGGER_NAME=qct.TRIGGER_NAME

• 
• Refer https://forums.saviynt.com/t5/identity-governance/requirement-analytic-report-to-identify-if-job-is-... 
• For other jobs 

select
  qt.TRIGGER_NAME 'Job Name',
  qct.CRON_EXPRESSION,
  FROM_UNIXTIME(qt.NEXT_FIRE_TIME/1000) 'Job next fire time',
  FROM_UNIXTIME(qt.PREV_FIRE_TIME/1000) 'Job previous fire time'
from
  qrtz_triggers qt, qrtz_cron_triggers qct
where
 
  qt.TRIGGER_NAME=qct.TRIGGER_NAME

• 
  

[dgandhi]

Use below query