David,
Here is the info you need (previously sent to me by David Chapa)
Regards
Andy Hardy
1)jobid,(2)jobtype,(3)state,(4)status,(5)class,(6)sched,(7)client,(8)ser
ver,(9)queuedtime,(10)elapsedfromqueuedtime,(11)endtime,(12)stunit,(13)b
ackuptry,(14)operationtype,
(15)kbytes,(16)files,(17)pathlastwritten,(18)percent,(19)jobpid,(20)owne
r,(21)subtype,(22)classtype,(23)schedule_type,(24)jobpriority,(25)group,
(26)masterserver,
(27)retentionunits,(28)retentionperiod,(29)compression,(30)kbyteslastwri
tten,(31)fileslastwritten,(32)filelistcount,(33*)[files]...,(34*)trycoun
t,[trypid,trystunit,tryserver,trystarted,tryelapsed,tryended,trystatus,t
rystatusdescription,trystatuscount,[trystatuslines]...,trybyteswritten,t
ryfileswritten]...
Everything up to Field 32 is fixed beyond that the output is dynamic and
you will find out how many name files in the files list based on the
number in field 32. If you add that number to 33 (next field) it will
take you to the number of tries the backup job attempted. For the first
try move over 4 to get the start time of the first try, 5 for the elapse
time of the first try, 6 for the end time of the first try, etc.
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of David Rock
Sent: 08 November 2004 02:41
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Vault info in bpdbjobs -all_columns output
Does anyone know what the fields in the vault info from bpdbjobs
-all_columns are? It's obvious that some of the fields are the same, but
a lot of them are not. It all starts to go wrong at column #13, which is
normally a "try" value. In a vault job, it appears to be the target
storage unit for the vault, or maybe it's the source stu, I can't tell
yet. Has anyone else tried to figure this out?
--
David Rock
david AT graniteweb DOT com
-----------------------------------------------------------------------
Registered Office:
Marks and Spencer plc
Waterside House
35 North Wharf Road
London
W2 1NW
Registered No. 214436 in England and Wales.
Telephone (020) 7935 4422
Facsimile (020) 7487 2670
www.marksandspencer.com
Please note that electronic mail may be monitored.
This e-mail is confidential. If you received it by mistake, please let us know
and then delete it from your system; you should not copy, disclose, or
distribute its contents to anyone nor act in reliance on this e-mail, as this
is prohibited and may be unlawful.
The registered office of Marks and Spencer Financial Services PLC, Marks and
Spencer Unit Trust Management Limited, Marks and Spencer Life Assurance Limited
and Marks and Spencer Savings and Investments Limited is Kings Meadow, Chester,
CH99 9FB. These firms are authorised and regulated by the Financial Services
Authority.
|