Hi "StartTime" does not get updated when migrating a job. Is this a bug or is it the way it is supposed to be?
mysql bacula -e "SELECT JobId, PriorJobId, SchedTime, StartTime, EndTime, RealEndTime FROM Job WHERE JobId IN (90018,89565)" +-------+------------+---------------------+---------------------+---------------------+---------------------+ | JobId | PriorJobId | SchedTime | StartTime | EndTime | RealEndTime | +-------+------------+---------------------+---------------------+---------------------+---------------------+ | 89565 | 0 | 2014-07-11 22:05:00 | 2014-07-12 01:52:48 | 2014-07-12 02:01:24 | 2014-07-12 02:01:24 | | 90018 | 89565 | 2014-07-22 08:50:48 | 2014-07-12 01:52:48 | 2014-07-12 02:01:24 | 2014-07-22 21:27:37 | +-------+------------+---------------------+---------------------+---------------------+---------------------+ In job 89565 StartTime is about 4 hours later than SchedTime. In job 90018 StartTime is 10 days before SchedTime. It is actually the jobs previous StartTime. My problem is that when I want to calculate the time used for migrating a job it get a wrong number with TIMEDIFF(RealEndTime,SchedTime). /hans ------------------------------------------------------------------------------ Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users