We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Job failures with missing enddate

Joon
Regular Contributor II
Regular Contributor II

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 ?

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

You can use ootb report long running jobs


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Joon
Regular Contributor II
Regular Contributor II

Hello Rushi,

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

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()


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.