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:graham AT equiinet DOT com] 
Gesendet: Mittwoch, 18. November 2009 11:42
An: bacula-users AT lists.sourceforge DOT 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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users