ADSM-L

Query Event VS Successful Flag

2003-04-16 09:41:09
Subject: Query Event VS Successful Flag
From: Gene Walters <gwalters AT GWMAIL.STATE.WV DOT US>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 16 Apr 2003 09:39:48 -0400
I Run a variety of queries each night, one being the query event,
another being a select statement on the summary table.  Here is a sample
of what I get:

The query event:

Scheduled Start     Actual Start        Schedule NameNode Name
Status
---------------------------------------------------------------------------
04/16/2003 01:00:00 04/16/2003 01:01:06 SQLBACKUP
WVWFISQLBACK-Failed

The select:
ACTIVITY          Server                     MB      Duration(Min)
K/Sec        SUCCESSFUL  Start Time    End Time
BACKUP            WVWFISQLBACKUP  439.09              6       1155.86
            YES           01:03:56    01:10:25

My question is:  which one of these do I believe, the query event or
the info from the summary table.  One says it failed, one says it was
successful?

Thanks
Gene

<Prev in Thread] Current Thread [Next in Thread>