The starting time from QUERY EVENT shows 01:01:06, while the starting time
from your SELECT shows 01:03:56. Are you sure these two outputs are for
the exact same event?

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Gene Walters <gwalters AT GWMAIL.STATE.WV DOT US>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04/16/2003 06:39
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Query Event VS Successful Flag



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