Aptare SQL query question

I need help with the following SQL query to generate a report for backup jobs that had failed more than 2 days so I can feed the results to our automation ticketing system. (the query used to work be...