Job failures with missing enddate

[Joon]

Hello Team,

We got a new case in EIC that When an instance is switched over by performance issue, Running jobs will be failed without enddate and no notification also.

Is there anyway that we could get notified from Analytics report When it's failed like this ?

[rushikeshvartak]

You can use ootb report long running jobs

[Joon]

Hello Rushi,

I can't find the report.. can you please help me to create one ?

[rushikeshvartak]

SELECT FROM_UNIXTIME(fired_time / 1000) AS start_time, NOW() AS CurrentTime, TIMESTAMPDIFF(HOUR, FROM_UNIXTIME(fired_time / 1000), NOW()) AS RunningTime_Hrs, trigger_name, job_name FROM qrtz_fired_triggers WHERE DATE_ADD(FROM_UNIXTIME(fired_time / 1000), INTERVAL 4 HOUR) < NOW()