I have a perl example that might start you down the right path. This script monitors a job id and emails out an hourly report until the job is complete. While it is not exactly what you are looking for, some key lines in it might assist with you parsing the bpdbjobs output and then only printing out the last 24hours based on some time match logic.
#!/usr/bin/perl
$jobnum = "1178415";
$subject = "Netbackup_Hourly_Job_Monitor_Status";
$master = "masterservername";
@emails = ('username@email.com');
$num = "0";
while($num ne "3"){
$output = `/usr/openv/netbackup/bin/admincmd/bpdbjobs -report -M $master -gdm -jobid $jobnum`;
($jobid,$jobtype,$state,$status,$class,$sched,$client,$server,$start,$elapsed,$end,$j1,$j2,$j3,$j4,$j5,$kilobytes,$j6,$j7) =
split (',',$output);
$gigabytes = ($kilobytes/1024)/1024;
$gigabytes = sprintf("%0.2f",$gigabytes);
$helapse = ($elapsed/60)/60;
$helapse = sprintf("%0.2f",$helapse);
sjobtype();
sjobstate();
open FILE, ">/tmp/NJMS.tmp";
print FILE " Client: $client \n";
close (FILE);
open FILE, ">>/tmp/NJMS.tmp";
print FILE " Media Server: $server \n";
print FILE " Job State: $rstate \n";
print FILE " Job Type: $rjobtype \n";
print FILE " Elapsed Time (hrs): $helapse\n";
print FILE " Gigabytes: $gigabytes\n";
close (FILE);
mailit();
$num = "$state";
sleep(3600);
}
exit;
sub sjobtype {
if ($jobtype eq "0") {
$rjobtype = "Backup";
} elsif ($jobtype eq "1") {
$rjobtype = "Archive";
} elsif ($jobtype eq "2") {
$rjobtype = "Restore";
} elsif ($jobtype eq "3") {
$rjobtype = "Verify";
} elsif ($jobtype eq "4") {
$rjobtype = "Duplication";
} elsif ($jobtype eq "5") {
$rjobtype = "Import";
} elsif ($jobtype eq "6") {
$rjobtype = "DBBackup";
} elsif ($jobtype eq "7") {
$rjobtype = "Vault";
} else {
$rjobtype = "Unknown";
}
}
sub sjobstate {
if ($state eq "0") {
$rstate = "Queued";
} elsif ($state eq "1") {
$rstate = "Active";
} elsif ($state eq "2") {
$rstate = "Requested";
} elsif ($state eq "3") {
$rstate = "Done";
} else {
$rstate = "Unknown";
}
}
sub mailit {
foreach $emails (@emails) {
$mailit = `/usr/bin/mailx -s $subject $emails < /tmp/NJMS.tmp`;
}
}
