What would be ok, since the idea behind the verify job is to verify the last job... Running a verify before the virtualfull would check the original job.
I just compiled it with the sql statement below. The verify just selected the right jobid... -----Ursprüngliche Nachricht----- Von: Graham Keeling [mailto:gra...@equiinet.com] Gesendet: Mittwoch, 18. November 2009 11:42 An: bacula-users@lists.sourceforge.net Betreff: Re: [Bacula-users] virtuafull and verify On Wed, Nov 18, 2009 at 11:29:38AM +0100, Fahrer, Julian wrote: > Hey, > > yes it seems tob e the same problem. > The sql statement in the sub "db_find_last_jobid" is: > "SELECT JobId FROM Job WHERE Type='B' AND JobStatus IN ('T','W') AND " > "Name='%s' ORDER BY StartTime DESC LIMIT 1", Name); > > I think changing it to something like > > "SELECT JobId FROM Job WHERE Type='B' AND JobStatus IN ('T','W') AND " > "Name='%s' ORDER BY StartTime DESC, JobId DESC LIMIT 1", Name); > > would fix the problem for me right now. But I am not sure what problems would > occure then... The obvious problem is that you wouldn't be able to verify the original job. :) > > Thanks for submitting my mail to the devil list ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
