That didn't come out right. ... Here is the report:
Scheduled Start Actual Start Schedule Name Node Name Status -------------------- -------------------- ------------- ------------- --------- 03/17/2004 20:00:00 03/18/2004 04:17:28 DAILY HOUCYPRSTA Failed 03/17/2004 20:00:00 03/18/2004 04:16:01 DAILY HOUNORTHSHORE Failed 03/17/2004 20:00:00 03/17/2004 21:01:28 DAILY HOUSARBOX Failed 03/17/2004 20:00:00 03/17/2004 20:36:53 DAILY HOUENDPOINT Failed 03/18/2004 00:00:00 SERVER-MIDNI- HOUCORP1 Missed GHT > -----Original Message----- > From: Coats, Jack [SMTP:[EMAIL PROTECTED] > Sent: Thursday, March 18, 2004 3:10 PM > To: [EMAIL PROTECTED] > Subject: Re: SQL Query Challenge > > Sorry, I should have been more explicit. > > Currently I run a query that is: > > QUERY EVENT * * BEGINDATE=TODAY-1 BEGINTIME=08:00 ENDDATE=TODAY > ENDTIME=NOW EXCEPTIONSONLY=YES FORMAT=STANDARD > >