MSEEE

SELECT CJ.MODIFIEDTS AS LASTRUN,CJ.P_CODE AS CRONJOB,J.P_CODE,CJ.P_STATUSMESSAGE,
CASE
    WHEN CJ.P_STATUS = ''8796097118299''
    THEN ''FINISHED''
    ELSE ''RUNNING''
    END AS Status,
CASE
    WHEN CJ.P_RESULT = ''8796097183835''
    THEN ''SUCCESS''
    ELSE ''ERROR''
    END AS LastResult
FROM CRONJOBS AS CJ
JOIN JOBS AS J ON CJ.P_JOB = J.PK
WHERE CJ.P_JOB IN (
                    SELECT PK FROM JOBS
                    WHERE P_CODE IN (
                    ''sync home24-ShopCatalog:Staged->Online'',
                    ''Sync Default:Staged -> Default:Online'',
					''assetHotFolderJob'',
					''categoryLinkingJob''
					)
                )
AND CJ.MODIFIEDTS >= ADD_DAYS(CURRENT_DATE, -1)
ORDER BY CJ.MODIFIEDTS DESC