Re: Query Event VS Successful Flag
2003-04-16 10:21:18
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
|
|
|