Hi,
The duration in the job detail window of BAT does not contain any formatting or
description of format and can easily misunderstand.
Sample:
Job runtime is 34 minutes and 41 seconds -> duration is 3146.
With the attached diff the difference between the start time and end time of a
job is formated as time and the above example become 00:31:46.
--- bacula-5.2.3_orig/src/qt-console/job/job.cpp 2012-01-06
16:27:35.969779651 +0100
+++ bacula-5.2.3/src/qt-console/job/job.cpp 2012-01-06 16:28:17.077347819
+0100
@@ -343,7 +343,7 @@
char buf[256];
QString query =
"SELECT JobId, Job.Name, Level, Client.Name, Pool.Name, FileSet,"
- "SchedTime, StartTime, EndTime, EndTime-StartTime AS Duration, "
+ "SchedTime, StartTime, EndTime, TIMEDIFF(EndTime,StartTime) AS Duration,
"
"JobBytes, JobFiles, JobErrors, JobStatus, PurgedFiles "
"FROM Job JOIN Client USING (ClientId) "
"LEFT JOIN Pool ON (Job.PoolId = Pool.PoolId) "
------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
