This is a multi-part message in MIME format.
------=_NextPart_000_00A6_01C2FA98.79710C20
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
bpdbjobs -all_columns
I believe the 9th, 10th and 11th fields are your start, elapse and end
utimes for the job. Now I believe it is the total elapse time for all
tries.
2682,0,3,0,Unix,Incrm,DS-sun,DS-sun,1049155449,0000000268,1049155717,DLT_BAC
KUP,1,,134848,5500,,,28302,root,1,0,1,0,,DS-sun,2,2,0,,,1,/,1,28302,DLT_BACK
UP,DS-sun,1049155449,0000000268,1049155717,0,the requested operation was
successfully completed,8,03/31/03 18:04:16 - connecting,03/31/03 18:04:16 -
connected; connect time: 000:00:00,03/31/03 18:04:17 - mounting
BKZ467,03/31/03 18:05:43 - mounted; mount time: 000:01:26,03/31/03
18:05:44 - positioning to file 13,03/31/03 18:06:18 - positioned; position
time: 000:00:34,03/31/03 18:06:18 - begin writing,03/31/03 18:08:09 - end
writing; write time: 000:01:51,134848,5500,0,1217,,,,,,,,,,,0
David
<><><><><><><><><><><><><><><><><><><><>
David A. Chapa
DataStaff, Inc.
312-683-1144
http://www.BackupScripts.com
"where script happens"
Post your questions in our forums
Co-Author of
Implementing Backup and Recovery:
The Readiness Guide for the Enterprise
published by John Wiley and Sons
A Veritas Solution Series Publication
ISBN:0471227145
---------------------------------------
-----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 Bosen
Sent: Friday, April 04, 2003 9:44 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] NB 4.5 job logging
I recently upgraded my server to NB 4.5 and lost the capability to
generate daily backup reports. I had a script that used the files under the
db/jobs and db/jobs/done directories to format an html report. I can see
where NB4.5 stores the .t and .f files, but where are the job files
themselves? Did they get absorbed into the bpjobd.db file?
I need to find the basic start/stop time and other info that used to
reside in the jobid files in 3.4. Does anyone know how to extract this info
under 4.5?
Dave Bosen
-----------------------------------------
AGL Resources - Atlanta, GA
404-584-4321
-----------------------------------------
------=_NextPart_000_00A6_01C2FA98.79710C20
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-WEIGHT: normal; COLOR: windowtext; FONT-STYLE: normal; =
FONT-FAMILY: Tahoma; TEXT-DECORATION: none
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US vLink=3Dpurple link=3Dblue>
<DIV><SPAN class=3D358564916-04042003><FONT face=3DArial color=3D#0000ff =
size=3D2>bpdbjobs -all_columns</FONT></SPAN></DIV>
<DIV><SPAN class=3D358564916-04042003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D358564916-04042003><FONT face=3DArial color=3D#0000ff =
size=3D2>I=20
believe the 9th, 10th and 11th fields are your start, elapse =
and end=20
utimes for the job. Now I believe it is the total elapse time for =
all=20
tries. </FONT></SPAN></DIV>
<DIV><SPAN class=3D358564916-04042003><FONT face=3DArial color=3D#0000ff =
size=3D2> </FONT></SPAN></DIV>
<DIV><SPAN class=3D358564916-04042003><FONT face=3DArial color=3D#0000ff =
size=3D2>2682,0,3,0,Unix,Incrm,DS-sun,DS-sun,1049155449,0000000268,104915=
5717,DLT_BACKUP,1,,134848,5500,,,28302,root,1,0,1,0,,DS-sun,2,2,0,,,1,/,1=
,28302,DLT_BACKUP,DS-sun,1049155449,0000000268,1049155717,0,the=20
requested operation was successfully completed,8,03/31/03 18:04:16 -=20
connecting,03/31/03 18:04:16 - connected; connect time: =
000:00:00,03/31/03=20
18:04:17 - mounting BKZ467,03/31/03 18:05:43 - mounted; mount time:=20
000:01:26,03/31/03 18:05:44 - positioning to file 13,03/31/03 18:06:18 - =
positioned; position time: 000:00:34,03/31/03 18:06:18 - begin =
writing,03/31/03=20
18:08:09 - end writing; write time:=20
000:01:51,134848,5500,0,1217,,,,,,,,,,,0</FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><SPAN class=3D358564916-04042003><FONT face=3DArial color=3D#0000ff =
size=3D2>David</FONT></SPAN></DIV>
<P><FONT=20
size=3D2><><><><><><><><>=
<><><><><><><><><>&=
lt;><><><BR>David=20
A. Chapa<BR>DataStaff, Inc.<BR>312-683-1144<BR><A=20
href=3D"http://www.backupscripts.com/"=20
target=3D_blank>http://www.BackupScripts.com</A><BR>"where script =
happens"<BR>Post=20
your questions in our forums<BR><BR>Co-Author of<BR>Implementing Backup =
and=20
Recovery:<BR>The Readiness Guide for the Enterprise<BR>published by John =
Wiley=20
and Sons<BR>A Veritas Solution Series=20
Publication<BR>ISBN:0471227145<BR>---------------------------------------=
</FONT>=20
</P>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]<B>On Behalf Of =
</B>David=20
Bosen<BR><B>Sent:</B> Friday, April 04, 2003 9:44 AM<BR><B>To:</B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> [Veritas-bu] NB =
4.5 job=20
logging<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">I recently upgraded my =
server to=20
NB 4.5 and lost the capability to generate daily backup reports. I had =
a=20
script that used the files under the db/jobs and db/jobs/done =
directories to=20
format an html report. I can see where NB4.5 stores the .t and .f =
files, but=20
where are the job files themselves? Did they get absorbed into the =
bpjobd.db=20
file?</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma"></SPAN></FONT> </P>
<P class=3DMsoNormal><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">I need to find the =
basic=20
start/stop time and other info that used to reside in the jobid files =
in 3.4.=20
Does anyone know how to extract this info under 4.5?</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma"></SPAN></FONT> </P>
<P class=3DMsoNormal><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Dave =
Bosen</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">-----------------------------------------</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">AGL Resources -=20
</SPAN></FONT><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">Atlanta</SPAN></FONT><FONT=20
face=3DTahoma size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">,=20
</SPAN></FONT><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">GA</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">404-584-4321</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">-----------------------------------------</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"></SPAN></FONT> </P></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_00A6_01C2FA98.79710C20--
|