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:Jack.Coats AT BANKSTERLING DOT COM]
> Sent: Thursday, March 18, 2004 3:10 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> 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
>
>