Trigger Type in Job History Details

[AS5278]

Hi All,

We can see different values for 'Trigger Type' column in the job history detail for any job.

Values are: system, user, GRAILS_JOB, MANUAL_TRIGGER.

I understand the trigger type 'system' and 'user'.

1). Trigger type 'system' means the job ran automatically based on schedule.

2). Trigger type 'user' means that a user manually ran the job trigger.

But what does the other two mean?. What does trigger type 'GRAILS_JOB' and 'MANUAL_TRIGGER' mean in job history detail page?.

Please advice.

Thanks.

[Raghu]

@AS5278  check below table you will get better idea of those

ecmimportjob ,

or excute below query in analytics you will get idea jobs

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

[dgandhi]

Normally have seen trigger type value of system and user.

Can you confirm the query that is used to fetch above output?

[rushikeshvartak · Accepted solution]

• GRAILS_JOB: Triggered by internal processes or routines within the Grails framework.
• MANUAL_TRIGGER: Triggered manually through scripts, API calls, or other non-UI methods.