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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users