On Mon, 20 Jun 2011, Gavin McCullagh wrote: > This seems quite close.... > > SELECT Job.Name, MAX(Job.RealEndTime) > FROM Job > WHERE Job.Type='B' AND Job.JobStatus='T' > GROUP BY Job.Name; > > but we have clients who manually trigger their own incremental (eg once per > week) and then there's a scheduled VirtualFull which runs every month.
Ah. It would appear that RealEndTime is the actual time the job ended, but StartTime and EndTime (in the case of a virtual full backup) seem to be the corresponding start and end times of the previous backup. That's at least a partial solution, in that I can use the EndTime. That previous backup could also be a virtual full, but I guess I might settle for that. Gavin ------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
