SELECT "SPOOLER_ID" AS "JOB_SCHEDULER", "JOB_NAME", "ERROR", 
       "START_TIME", "END_TIME", "END_TIME"-"START_TIME" AS "ELAPSED" 
  FROM SCHEDULER_HISTORY
 WHERE "START_TIME" >= CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME) - 10
   AND COALESCE("END_TIME", GETDATE() - 1) <= GETDATE()
   AND "JOB_NAME" <> '(Spooler)'
 GROUP BY "SPOOLER_ID", "JOB_NAME", "ERROR", "START_TIME", "END_TIME", "END_TIME"-"START_TIME";